Format property

[radek225]

In my form:
If I want to have cubic meter format of my control, then I type

&" m³"

if I want to have thousands separator then I type

# ###

How should format look like for cubic meter control and thousands separator. In addition, this control should has three decimal places, but only when decimal places aren't null e.g.
If I have 231 should display 231 not 231,000
if I have 231,23 should display 231,23 not 231,230

 

[arnelgp]

i think you can't specially if your form is continuous.

 

[Ranman256]

i wouldnt put the meter symbol IN the format, instead just put it as a label outside the box.

not sure access can do a NO COMMA format.

 

[radek225]

i think you can't specially if your form is continuous.

Hmm ok, but what If my form isn't continous? Is there some solution?

 

[arnelgp]

there is none, all records will take the same format.

 

[radek225]

there is none, all records will take the same format.

it's ok for me. How could I join # ### and &" m³" in a one format?

 

[arnelgp]

just use the Format property of the control:

Format: #,###" m³"

 

[radek225]

just use the Format property of the control:

Format: #,###" m³"

It's fine for me. Could you tell me how should I set it using VBA?
When I do

Me.WolumenSumaryczny.Format = "# ###" & "," & "####" & " MWh"

then get something like

#\ # ###" MWh"

:/

 

[arnelgp]

Me.WolumenSumaryczny.Format ="#,##0 \M\W\h"