Pound and Euro Symbol

[mpd]

Can someone suggest how I can solve the following: I have a form with a text box called [Item_Price]. I have a check box called Euro. What I want to happen is that if the check box is ticked then the value in the [Item_Price] field to appear with the € but if the check box is not ticked then the amount in [Item_Price] to appear with £.

Any ideas?

 

[Mile-O]

I suppose you could put a hidden textbox on your form that holds the actual currency value and the one you have can show a string representation of the currency value concatenated with the currency symbol.

 

[AncientOne]

How are the values stored in your table? As Euiros and pounds in two separate columns? If so, you can use a simple IIF statement to select which column to display.