Prefill with zeros

[bzsurf03]

In Access, how do you set the format of a 17-byte text field to prefill with zeros so the value will always be 17 bytes long not matter how short the value is?

Example:
Value is 1033 needs to be 00000000000001033.

Thanks in advance.

 

[SkipVought]

Hi,

Format([MyNumber],"00000000000000000")

Skip,
[sub]
[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More![/sub]

 

[bzsurf03]

skip,

Where should i paste this? It didn't seem to work when I pasted into the format property of the field.

Here's some more info:

Field type = Text
Field length = 17
Field name = Total Amt

Thanks.

 

[SkipVought]

Its NOT a format - it's TEXT.

I'd use the Exit event to run a procedure like...

 [MyTextBox].Text = Format([MyTextBox].Text,"00000000000000000")

Skip,
[sub]
[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More![/sub]