Leading 0's Number Format

[RedHeadedMonster via AccessMonster.com]

I have an item in a table that is a number, I have the number format stored
as 0001, for example. It is a tracking number of changes and it increments
everytime a new change is added to the DB. The number works fine, format
works fine, until I concatenate it with another field. When I do that I get

test-1 Instead of test -0001

Anyone know of a way to keep the format when concatenating it with another
field.

Thanx!

RHM

 

[Douglas J. Steele]

"Test-" & Format(NumericValue, "0000")

 

[Klatuu]

First, your number is not stored as 0001. It is stored as 1. The format
property of the field only identifies how it should be presented visually.
The Format property, in other words, has no effect on how the data is
stored.

Use the Format function to get the value you need:

= "test-" & Format(MyNumber, "0000")