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?

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Luis" <(E-Mail Removed)> wrote in message
news:564FDD84-2EA6-46B8-AAFB-(E-Mail Removed)...
> 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?

On Aug 2, 1:54 pm, Luis <L...@discussions.microsoft.com> wrote:
> 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