Number of decimal places ...

  • Thread starter Thread starter Bob Howard
  • Start date Start date
B

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.
 
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
 
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)?
Click to expand...

Yes.

Jamie.

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

I usually use

Format$(0.2, 'currency')

and less often the FormatCurrency() VBA function.

Jamie.

--
 
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
 
what's the difference between Format and Format$ ?
Click to expand...

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?
Click to expand...

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

Jamie.

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

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

Jamie.
Click to expand...

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

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

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