Number of decimal places ...

[Bob Howard]

I want to "internationalize" my application and have been doing some reading
on the matter.

I want (wherever possible) to have the application adhere to the Windows
regional setting.

I read that Access supports 4 decimal places for currency. Does the
"currency" data type (in the table) always saved with 4 decimal places
(regardless of the number of decimal places displayed in the screen)?

In the "unbound" control used to capture the "money" amount, do I set the #
of decimal places to "Auto" ?? Is that what tells Access to use the # of
decimal places in the Windows regional setting??

Bob.

 

[Bob Howard]

addendum ...

And, for an unbound control representing a currency amount, how do I get it
to display the "currency" as specified in the Windows Regional Settings
(like the British Pound symbol, etc.)?

I seem to read (in "help") that Access will utilize the Windows Regional
Settings info only if the "Format" property of the control is omitted ...
but again, this is an unbound control so how would Access even know that
it's currenty unless I told it so (by specifying "currency")?

Bob

 

[Jamie Collins]

I read that Access supports 4 decimalplaces for currency. Does the
"currency" data type (in the table) always saved with 4 decimal places
(regardless of the number ofdecimalplaces displayed in the screen)?

Yes.

Jamie.

--

 

[Jamie Collins]

how do I get it
to display the "currency" as specified in the Windows Regional Settings
(like the British Pound symbol, etc.)?

I usually use

Format$(0.2, 'currency')

and less often the FormatCurrency() VBA function.

Jamie.

--

 

[Bob Howard]

Jamie --- thanks! I think I understand...

So I omit a Format property for the unbound control and use the Format
function to move the data to the control ... correct?

Also, what's the difference between Format and Format$ ?

Bob

 

[Jamie Collins]

what's the difference between Format and Format$ ?

Nothing of much consequence in VBA code (e.g. when you use the VS2005
Visual Basic Upgrade Wizard it issues a warning for Format but not for
Format$), no difference at all AFAIK in Access/Jet SQL code.

So I omit a Format property for the unbound control and use the Format
function to move the data to the control ... correct?

I'm in the Forms group?! [Runs]

Jamie.

--

 

[Bob Howard]

So I omit a Format property for the unbound control and use the Format

function to move the data to the control ... correct?

I'm in the Forms group?! [Runs]

Jamie.

Hi again --- sory I must be dense --- please explain... "forms group [Runs]"

Bob

 

[Jamie Collins]

Hi again --- sory I must be dense --- please explain... "forms group [Runs]"

Do you see that Jamie-shaped hole in the
microsoft.public.access.formscoding room door?