Thousand Separator (Comma) in Forms

[davies107]

Hello everyone,

I have a problem regarding the thousand (number) separator or the "comma" in my Form. I already tried Standard, Currency, Fixed but still the number in thousand looks like this - 12345.67 , i want it to be 12,346 (round off).

I even tried replacing Standard in the Property Sheet to #,### but to no avail.

My Tables and Queries are perfect - with separator or comma, it is also rounded or no decimal at all but why is it it doesnt follow to my Form.

Been researching a lot of resources but still I cant change the data on my Form no matter how I change the Property Sheet.

Any help is highly appreciated. Thanks a lot!

 

[John Big Booty]

On you field's Format tab, try setting Format to Standard and Decimal Places to 0

 

[davies107]

i tried it also John, i tried also Auto but still it wont appear. i refresh everything, i saved, i compact and repair.

 

[Galaxiom]

Is the ControlSource bound to a text field rather than a number?

 

[davies107]

the ControlSource has a command function (=[SearchResults].[column](17)) not bound to text or number...

 

[Galaxiom]

Except for the BoundColumn, columns in listboxes are text strings hence it is not treated as a number.

Try changing the ControlSource to:
=CInt([SearchResults].[column](17))

Leave the Format as Standard.

 

[davies107]

i changed it and it gives me this error : #Num! <--- instead of numbers.

i leave the format to Standard with 0 decimal.

 

[davies107]

i got it. its not CInt (integer) but CLng (long integer)...

Thanks guys!