How to Change Currency in Access

[moontage]

Hello,

I am trying to change the currency from "$" to a custom "AFS" which is not exist in Access how change this?

Thank you

[CJ_London]

use the format function or property - note using the function will convert the number to text (so you can't add, subtract etc) but using the property, you can

e.g. for Uk you could format as

£#,###.00

[orange]

You could have a separate field to indicate the "currency", and some function to calculate the relationship between 1$ and 1 "AFS". You could still do arithmetic with the value field; then show the currency type $ or AFS in a separate field for display.