Display a long integer with a space in it? 1

[gusbrunston]

For display purposes, is there a way I can display a long integer with a space between specific digits? e.g.,

NameID (long integer) = 3246001

Display as:             3246 001

Maybe convert the long integer to a string and then manipulate the string?

This is not a big deal--cosmetic only; but thanks if you have an idea.
Gus Brunston
An old PICKer
padregus@home.com

 

[LonnieJohnson]

Go to the form's design view. In the properties window for your textbox that displays the number (I am assuming this is on a form) go to the format property. Type...

0000\ \000

B-) ljprodev@yahoo.com
ProDev
MS Access Applications

 

[LonnieJohnson]

Sorry, remove the backslashes. Just use

0000 000

Good luck. B-) ljprodev@yahoo.com
ProDev
MS Access Applications

 

[gusbrunston]

Thanks, Lonnie. That worked great. Gus Brunston
An old PICKer
padregus@home.com