format property is being modified

[Bob Howard]

I have a form with Currency specified in several bound controls. My
application is used in several countries, so I wanted to see what would
happen if I changed my Windows Regional Settings to pretend I was in a
different country by setting a different Currency format (in Windows
Regional Settings).

So I ran some tests, and everything looked OK.

Afterwards, I changed the Windows Regional Settings back to standard US
format for the Currency. But when I tested the application, the money
fields on the form still looked as they did when I was doing the test!

So I looked at the properties for those controls, and they no longer
contained the word Currency --- they contained the actual format string for
the currency format I was testing with earlier.

Why would Access internally modify my format property like that --- and
leave it that way!

This is Access 2003...

By the way, when I move data to an unbound field using the Format function
(specifying Currency) everything works fine...

Bob

 

[Allen Browne]

Bob, it may suprise you to know that Access was intentionally designed to
behave as you describe.

Details in:
Currency format lost when regional settings change
at:
http://allenbrowne.com/ser-44.html

 

[Bob Howard]

Thanks ... you came thru again! (but what a mess!).

I've worked around it by coding =Format([....],"Currency") as the control
source (rather than simply [....]).

I've got another question --- I'll post it separately...

Bob.

 

[Allen Browne]

Yes, that would work for display only.

(You can't edit values in a control like that, of course.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks ... you came thru again! (but what a mess!).

I've worked around it by coding =Format([....],"Currency") as the control
source (rather than simply [....]).

I've got another question --- I'll post it separately...

Bob.

Bob, it may suprise you to know that Access was intentionally designed to
behave as you describe.

Details in:
Currency format lost when regional settings change
at:
http://allenbrowne.com/ser-44.html

 

[Bob Howard]

I'll have to further check out the ability to edit the value ... I seem to
recall that I did edit it, and it got stored in the table correctly... bob

Yes, that would work for display only.

(You can't edit values in a control like that, of course.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks ... you came thru again! (but what a mess!).

I've worked around it by coding =Format([....],"Currency") as the control
source (rather than simply [....]).

I've got another question --- I'll post it separately...

Bob.

Bob, it may suprise you to know that Access was intentionally designed
to behave as you describe.

Details in:
Currency format lost when regional settings change
at:
http://allenbrowne.com/ser-44.html

I have a form with Currency specified in several bound controls. My
application is used in several countries, so I wanted to see what would
happen if I changed my Windows Regional Settings to pretend I was in a
different country by setting a different Currency format (in Windows
Regional Settings).

So I ran some tests, and everything looked OK.

Afterwards, I changed the Windows Regional Settings back to standard US
format for the Currency. But when I tested the application, the money
fields on the form still looked as they did when I was doing the test!

So I looked at the properties for those controls, and they no longer
contained the word Currency --- they contained the actual format string
for the currency format I was testing with earlier.

Why would Access internally modify my format property like that --- and
leave it that way!

This is Access 2003...

By the way, when I move data to an unbound field using the Format
function (specifying Currency) everything works fine...

 

[Bob Howard]

You were correct ... the field where I input money is unbound and all the
others are bound, but read-only (they are various totals, etc.). Bob.

Yes, that would work for display only.

(You can't edit values in a control like that, of course.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks ... you came thru again! (but what a mess!).

I've worked around it by coding =Format([....],"Currency") as the control
source (rather than simply [....]).

I've got another question --- I'll post it separately...

Bob.

Bob, it may suprise you to know that Access was intentionally designed
to behave as you describe.

Details in:
Currency format lost when regional settings change
at:
http://allenbrowne.com/ser-44.html

I have a form with Currency specified in several bound controls. My
application is used in several countries, so I wanted to see what would
happen if I changed my Windows Regional Settings to pretend I was in a
different country by setting a different Currency format (in Windows
Regional Settings).

So I ran some tests, and everything looked OK.

Afterwards, I changed the Windows Regional Settings back to standard US
format for the Currency. But when I tested the application, the money
fields on the form still looked as they did when I was doing the test!

So I looked at the properties for those controls, and they no longer
contained the word Currency --- they contained the actual format string
for the currency format I was testing with earlier.

Why would Access internally modify my format property like that --- and
leave it that way!

This is Access 2003...

By the way, when I move data to an unbound field using the Format
function (specifying Currency) everything works fine...