Format string

[Luis]

Hello.
I'm using VBA to build a Word document from a Access table.
I need to format a strng but i didn't found out how yet.

The original string is for example 999999€ and the result i'd like is
999.999€.

If the string is 1000000€ the goal is to format it to 1.000.000€

Can anyone give me a hint?

Thanks

Luis

 

[Alex Dybenko]

Hi,
if this is a number - you can use Format function:

format(1000000,"#,###,##0")

else you can write some string manipulations using left, right, mid to
insert dots in between

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Paolo]

Hi luis,

Format(yourstring,"Currency")
in this way if your string is 1000000 the result is € 1.000.000

if yourstring is 999999€
Format(left(yourstring,len(yourstring)-1),"#.### €")

HTH Paolo