What code should I use to set a specific field format using the on load event.
For example my database is used by different countries. in their setup the can choose to use Euro or GBP as Currency.
When they log on I set this as a global constant (GbCurrency)
Depending on their setting when they load certain reports or forms I want certain fields to be formatted either as "currency" or as "Euro" in the format settings with the decimal place as 2.
i have enterd the following code but it doesn't work.
Any suggestions?
On load event
If gbCurrency = "Euro" Then
Me.labour_rate.Format = Euro
Me.labour_rate.DecimalPlaces = 2
end if
For example my database is used by different countries. in their setup the can choose to use Euro or GBP as Currency.
When they log on I set this as a global constant (GbCurrency)
Depending on their setting when they load certain reports or forms I want certain fields to be formatted either as "currency" or as "Euro" in the format settings with the decimal place as 2.
i have enterd the following code but it doesn't work.
Any suggestions?
On load event
If gbCurrency = "Euro" Then
Me.labour_rate.Format = Euro
Me.labour_rate.DecimalPlaces = 2
end if
