how to: prefix or suffix 0s automatically 1

[zyrag]

i have a numeric field with a 6-digit fix-length and i want to automatically prefix the entry with 0s if the entry is of less than the 6-digit length. Can i make this within the table-field-column specification? say, with the "default property"? How?

I will be using vb6 as the front-end.

thanks,

 

[hymn]

try
in the Format type in the 000000 and see what happens

Hope this helps
Hymn

 

[zyrag]

thanks hym... it worked for prefixing the entry with 0s but, how about suffixing 0s?

 

[hymn]

I am unsure what your after

Can't you just type them in i.e.
1000=001000

Hope this helps
Hymn

 

[zyrag]

don't mind it... got it working now. I would actually want to suffix say, 99 (depending on the reason_code) on the user's entry. I tried your way (format 000099) and it also worked fine and from there i was able to do it dynamically by coding in VB.

thanks a lot,