Format text

[Guest]

Hello.
I need to pass some values to a word document. These values come from a
table and the format is text.
What i need is to format the variable value from text to currency (€).

Is this possible?

 

[Douglas J. Steele]

Try creating a query and using the Format function in that query (as opposed
to the Format property of the field).

 

[IUnderstandSomething]

Hello.
I need to pass some values to a word document. These values come from a
table and the format is text.
What i need is to format the variable value from text to currency (€).

Is this possible?

Yes just add € ; "€ " & mytext

Sincerely

Hans Kristian Eide