Strange display of a number when currency symbol added

[Paul]

Very odd one here. The same text box control on two reports:

=[Total price]+[VAT]

I have added a different currency symbol to each:

="£" & [Total price]+[VAT]
="₪" & [Total price]+[VAT]

At first, both display, for example, 15.50 but after the change I get

£15.50
₪15.5

I cannot get the second decimal point to display! I have played with
'format' (=standard) settings and decimal point settings as well as
resizing the control just in case. But no luck! All the other fields,
including [Total price] and [VAT] look completely normal.

Any ideas?

 

[Roger Carlson]

Try this:

="£" & Format([Total price]+[VAT], "0.00")
="?" & Format([Total price]+[VAT], "0.00")

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Very odd one here. The same text box control on two reports:

=[Total price]+[VAT]

I have added a different currency symbol to each:

="£" & [Total price]+[VAT]
="?" & [Total price]+[VAT]

At first, both display, for example, 15.50 but after the change I get

£15.50
?15.5

I cannot get the second decimal point to display! I have played with
'format' (=standard) settings and decimal point settings as well as
resizing the control just in case. But no luck! All the other fields,
including [Total price] and [VAT] look completely normal.

Any ideas?

 

[Paul]

Yup, that did it - thanks!

But, just for interest's sake, do you have any idea why that extra
character (especially when it's only THAT character) would change the
format?

 

[Roger Carlson]

Is it the question mark? Because in the message I responded to, the
character was something other than the question mark, but in my response, it
turned into one. Very odd. If it was the question mark originally, I'd
guess that Access got confused because it uses the question mark as a
wildcard character.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Yup, that did it - thanks!

But, just for interest's sake, do you have any idea why that extra
character (especially when it's only THAT character) would change the
format?

 

[Paul]

Yes, it was a question mark. No wonder it behaved strangely! I'm not
going to worry about it anyway - you've solved the problem and that's
enough for me!

Thanks again,

Paul

Is it the question mark? Because in the message I responded to, the
character was something other than the question mark, but in my response,it
turned into one. Very odd. If it was the question mark originally, I'd
guess that Access got confused because it uses the question mark as a
wildcard character.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Yup, that did it - thanks!

But, just for interest's sake, do you have any idea why that extra
character (especially when it's only THAT character) would change the
format?

Try this:

="£" & Format([Total price]+[VAT], "0.00")
="?" & Format([Total price]+[VAT], "0.00")

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Very odd one here. The same text box control on two reports:

=[Total price]+[VAT]

I have added a different currency symbol to each:

="£" & [Total price]+[VAT]
="?" & [Total price]+[VAT]

At first, both display, for example, 15.50 but after the change I get

£15.50
?15.5

I cannot get the second decimal point to display! I have played with
'format' (=standard) settings and decimal point settings as well as
resizing the control just in case. But no luck! All the other fields,
including [Total price] and [VAT] look completely normal.

Any ideas?