XDR in value field (1 Viewer)

[johankotze]

I currently saw then there is XDR behind each value in value field of my subform. It was not there before.

 

[arnelgp]

i have Googled what a XDR is but not sure if what you are mentioning is the same.
can you show a snapshot?

 

[johankotze]

Hi Arnelgp attach is snapshot

 

[MajP]

What is the controlsource of the value field? My guess it is a calculated control or calculated colum or calculated field.

 

[isladogs]

Currency symbol? XDR — IMF Special Drawing Rights
Change the datatype from Currency to Number

 

[johankotze]

Currency symbol? XDR — IMF Special Drawing Rights
Change the datatype from Currency to Number

thx ilsadogs, will do and revert back

 

[johankotze]

I have change currency to number. But why did the currency change to XDR currency automatically as I did not change it. Is it some setting in windows that I can change.

 

[isladogs]

XDR is such an unusual currency that I would be very surprised if its been set in Windows.
You can check by typing Currency in Windows settings . This form should appear
As I'm UK based, mine is set to £

I may be wrong but think its much more likely that you somehow set the formatting to this by mistake in Access