Using a comma instead of a decimal point

[RexesOperator]

Well if you won't answer about changing label formats based on text-box values perhaps you'll have a look at this. And I have searched this and other sites.

I have a report that I have to be able to output in French as well as English (Canajian eh?). I have the regional settings in Canadian English because everything else I do is in Canadian English. I don't want to change the settings to Canadian French because of the complications this causes with the rest of the program.

I have no problem manually entering the diacritic marks for alphabetical characters, but how do I change the decimal point in numbers to a comma? And put the currency symbol after the amount? ie $10.15 (English) = 10,15$ (French). For non-currency amounts, 0.32 = 0,32

I suspect the answer is using the split function, but I have no idea how to apply it. Or (ideally) can a function be built to do this? Remember I don't know VBA and may need some hand-holding on this one.

 

[Michael J Ross]

Declare the following function in your modules

Function Conversion()
Conversion = Replace([Reports]![Nameofyourreport]![nameoftextfield], ".", ",") & "$"
End Function

Add a new text box for your french field to your report and set it's control source to =Conversion()

 

[RexesOperator]

Thank you sir - a scholar and a gentleman! I won't have time to check it until tomorrow, but it looks right. I will let you know if it works.

 

[RexesOperator]

The use of the replace function gave me an idea this might be simpler than I thought. After checking the Help in Access (one of the few times it has been useful), I discovered I can use it on an item by item basis. Cumbersome but it works. I did try your function, but couldn't get it to give me the answer I was looking for - undoubtedly I was doing something wrong. Replace works. Less elegant but thanks for pointing me in the right direction.