Formatting a number (number -> string)

[Damir Dezeljin]

Hi.

I have a Double number which I would like to format to display it in a
Label box. How can I do this (I would like to set thousent separator to
'.' and decimal separator to ',' with two decimal places).

BTW: Is there any way to set a TextBox value in Access reports from
Event procedures?

Best regards,
Dezo

 

[George Nicholson]

1) Label.Caption=Format(YourDouble,"Standard")

2) Each section of a Report (Headers, Footers, Detail) have Format events
which allow you to set the values of controls within those sections. You
could also do it earlier during the Report Open event, etc. It all depends
on how early you know if you need to or what the value should be...

HTH,