Having issue on format property

[Benjamins via AccessMonster.com]

Hi,

I have a text box that allow user to enter a numeric figure. I need a format
that will allow me to do so.

Example:
User Entry System result
1234 1,234
12.3 12.3
1234.56 1,234.56
1234567.898 1,234,567.898

I have try many format but it does not result that i wanted.

Need recommandation on what fomat should i use. Thanks!

 

[kc-mass]

What result do you want?

 

[Benjamins via AccessMonster.com]

Example:
User Entry Wanted result
1234 1,234
12.3 12.3
1234.56 1,234.56
1234567.898 1,234,567.898

What result do you want?

Hi,

[quoted text clipped - 12 lines]

Need recommandation on what fomat should i use. Thanks!

 

[John W. Vinson]

Example:
User Entry Wanted result
1234 1,234
12.3 12.3
1234.56 1,234.56
1234567.898 1,234,567.898

You'll need some VBA code to parse the result. Format will let you either
include or omit a decimal place... but not omit it if the fractional part is
zero and include it otherwise, at least as far as I know.