Forms, Formats, and Contents

Forms, Formats, and Contents

was studying the excellent Francesco Balena book, “ProgrammingVisual Basic 6.0,” edited by Microsoft Press, the cost of which iswidely compensated by both the book and the enclosed CD contents&#151:when Iran into the explanation of DataFormat property for data bound controls,and of StdDataFormat object. It seemed a very interesting subject for anarticle, so here it is. At the same time, I thank Francesco for thisopportunity.

One of DAO (and RDO) defects is that in order to view data in adefinite format we must write specific code when reading or writing data (toconvert a viewing formatted value into field formatted one and viceversa), andthis defect influences the data editing phase and the input one too.

ADO exposes the DataFormatproperty for data bound controls, that allow us to view data in the wanted format,while it remains in its native format in the table field. Custom formats arepossible too. DataFormat property sets or returns a format object, not aformat string, as you might think if you are familiar with Format$function. This object has not only some properties, in which the obvious Formatone, but also very useful events (which I’ll speak about afterwards).

Yet, for more demandingformatting needs, such as the currency conversion ones, for example, DataFormatproperty may turn out to be insufficient. Let’s suppose we have a productstable with prices in Currency format, and set in the currency of yourcountry. We can set DataFormat property as Currency and so weget, since our system is so set, a custom format for our currency. Everythingworks very well: we ‘see’ the prices in Currency format on the form andin numeric format in the table. Let’s make things a bit more complex now, bydisplaying values as Euro currency on the form while continuing to keep thevalue in the native currency in the database table. This task requires somecode for conversions between the currencies and a different format for eachone.

That’s why a library providedwith VB (“Microsoft Data Formatting Object Library”) isuseful: it exposes StdDataFormat object. Once we have instanced such anobject, we can set the properties we are interested in (the Type property inparticular), assign it to a data bound control DataFormat property andtake advantage of Format and UnFormat events, that represent itsreal power.

The Format event raiseswhen data is ‘read’ from the data source and is about to be displayed in thebound control (more in general, used by the data consumer), whereas the UnFormatevent raises when a data bound control value (if changed) is written back tothe data source. This means that we have two places which we can write code,for complex formatting operations, instead of writing in several places, as wemust do with a DAO (or RDO) control.

Another very interesting aspect is that it’s not necessary we set theproperties of a StdDataFormat object: we can just take advantage of itsevents to manage by code the formatting operations, as in this case, when acurrency conversion is involved.

If we don’t use a StdDataFormatobject (that is we rely on DataFormat property only) these propertiesand events are managed implicitly. Nevertheless my idea is of dealing withEuro-other currency conversion, without creating a new field in the table, andwith as little code quantity as possible. As a matter of fact I need to translatethe displayed data in the selected currency (Euro or my currency), keeping theoriginal format (in my currency) in the data source table.

The Study Project, Step by Step
Create a new project, select it in Project Window and name it as EuroConvert.
Select Form1 and name it frmProdotti; set its Caption as “Products”.
Add the “Microsoft ADO Data Control 6.0 (SP3)(OLEDB)” to theproject components.
Add the “Microsoft Data Formatting Object Library” to theproject references.
Add to frmProdotti an ADODC control (Adodc1), and set its Alignproperty as 2 – vbAlignBottom.
Click on Adodc1 with the right mouse button and select Properties:In the General tab set the connection source as ‘Use connectionstring‘, click on Generate button, select “Microsoft Jet3.51 OLE DB Provider”, then click on Next button and then onthe little button on the right of the textbox to select file Nwind.mdb,that is in the same VB folder; verify the connection clicking on the properbutton and then on OK button.
TAKE CARE: during this study the data will be changed. Therefore, if you wantto save the original file, get a copy of it to restore the fact before thestudy.
In the RecordSource tab of Properties dialog for Adodc1,set the Command Type as 2 – adCmdTabel and select Productstable.

Add to frmProdotti a textbox and a label for two fields of the table (ProductName,UnitPrice) setting adequately first the DataSource property forthe textboxes (Text1 and Text2 ) as Adodc1 and then the DataFieldone to the relative field, then ‘copy’ the name of the field and ‘paste’ it inthe Caption property of the relative label (Label1 and Label2).
Near the Text2 textbox, the one for the price, put an OptionButton (Option1),’copy’ it and ‘paste’ it and answer ‘Yes’ to get a two OptionButton array (Option1(0)and Option1(1)), set their Caption property as “ourcurrency” and “Euro”, respectively; the former Valueproperty is set as True (I’m calling ‘our currency’ what you must intendfor French, or German, or other country currency).

Normal Situation
Let’sset Text2 DataFormat property by clicking on the ellipsis buttonand selecting Currency. Then click OK: now we have our textboxvisualizing our currency in our known format. Eventually, the format is acustom one (for VB), if it’s not a standard format. Now we can run ourapplication and try to change the values in the price textbox. We realize thatthe currency symbol ($, L, D,

devx-admin

devx-admin

Share the Post:
Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India,

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor

Revolutionized Low-Code

You Should Use Low-Code Platforms for Apps

As the demand for rapid software development increases, low-code platforms have emerged as a popular choice among developers for their ability to build applications with

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in and explore the leaders in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India, and kickstart your journey to

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner for your online project. Your

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the state. A Senate committee meeting

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor supply chain and enhance its

Revolutionized Low-Code

You Should Use Low-Code Platforms for Apps

As the demand for rapid software development increases, low-code platforms have emerged as a popular choice among developers for their ability to build applications with minimal coding. These platforms not

Cybersecurity Strategy

Five Powerful Strategies to Bolster Your Cybersecurity

In today’s increasingly digital landscape, businesses of all sizes must prioritize cyber security measures to defend against potential dangers. Cyber security professionals suggest five simple technological strategies to help companies

Global Layoffs

Tech Layoffs Are Getting Worse Globally

Since the start of 2023, the global technology sector has experienced a significant rise in layoffs, with over 236,000 workers being let go by 1,019 tech firms, as per data

Huawei Electric Dazzle

Huawei Dazzles with Electric Vehicles and Wireless Earbuds

During a prominent unveiling event, Huawei, the Chinese telecommunications powerhouse, kept quiet about its enigmatic new 5G phone and alleged cutting-edge chip development. Instead, Huawei astounded the audience by presenting

Cybersecurity Banking Revolution

Digital Banking Needs Cybersecurity

The banking, financial, and insurance (BFSI) sectors are pioneers in digital transformation, using web applications and application programming interfaces (APIs) to provide seamless services to customers around the world. Rising

FinTech Leadership

Terry Clune’s Fintech Empire

Over the past 30 years, Terry Clune has built a remarkable business empire, with CluneTech at the helm. The CEO and Founder has successfully created eight fintech firms, attracting renowned

The Role Of AI Within A Web Design Agency?

In the digital age, the role of Artificial Intelligence (AI) in web design is rapidly evolving, transitioning from a futuristic concept to practical tools used in design, coding, content writing

Generative AI Revolution

Is Generative AI the Next Internet?

The increasing demand for Generative AI models has led to a surge in its adoption across diverse sectors, with healthcare, automotive, and financial services being among the top beneficiaries. These

Microsoft Laptop

The New Surface Laptop Studio 2 Is Nuts

The Surface Laptop Studio 2 is a dynamic and robust all-in-one laptop designed for creators and professionals alike. It features a 14.4″ touchscreen and a cutting-edge design that is over

5G Innovations

GPU-Accelerated 5G in Japan

NTT DOCOMO, a global telecommunications giant, is set to break new ground in the industry as it prepares to launch a GPU-accelerated 5G network in Japan. This innovative approach will

AI Ethics

AI Journalism: Balancing Integrity and Innovation

An op-ed, produced using Microsoft’s Bing Chat AI software, recently appeared in the St. Louis Post-Dispatch, discussing the potential concerns surrounding the employment of artificial intelligence (AI) in journalism. These

Savings Extravaganza

Big Deal Days Extravaganza

The highly awaited Big Deal Days event for October 2023 is nearly here, scheduled for the 10th and 11th. Similar to the previous year, this autumn sale has already created

Cisco Splunk Deal

Cisco Splunk Deal Sparks Tech Acquisition Frenzy

Cisco’s recent massive purchase of Splunk, an AI-powered cybersecurity firm, for $28 billion signals a potential boost in tech deals after a year of subdued mergers and acquisitions in the

Iran Drone Expansion

Iran’s Jet-Propelled Drone Reshapes Power Balance

Iran has recently unveiled a jet-propelled variant of its Shahed series drone, marking a significant advancement in the nation’s drone technology. The new drone is poised to reshape the regional

Solar Geoengineering

Did the Overshoot Commission Shoot Down Geoengineering?

The Overshoot Commission has recently released a comprehensive report that discusses the controversial topic of Solar Geoengineering, also known as Solar Radiation Modification (SRM). The Commission’s primary objective is to

Remote Learning

Revolutionizing Remote Learning for Success

School districts are preparing to reveal a substantial technological upgrade designed to significantly improve remote learning experiences for both educators and students amid the ongoing pandemic. This major investment, which

Revolutionary SABERS Transforming

SABERS Batteries Transforming Industries

Scientists John Connell and Yi Lin from NASA’s Solid-state Architecture Batteries for Enhanced Rechargeability and Safety (SABERS) project are working on experimental solid-state battery packs that could dramatically change the

Build a Website

How Much Does It Cost to Build a Website?

Are you wondering how much it costs to build a website? The approximated cost is based on several factors, including which add-ons and platforms you choose. For example, a self-hosted

Battery Investments

Battery Startups Attract Billion-Dollar Investments

In recent times, battery startups have experienced a significant boost in investments, with three businesses obtaining over $1 billion in funding within the last month. French company Verkor amassed $2.1