Format to result in 4 digits

[Design by Sue]

This has to end.

Either change the field from a Number to a string or apply the appropriate format in controls where it's needed.

That was it!!!!! I adapted this code from elsewhere in my database and forgot to change the declaration for this field. The previous field (in the old code) was a number and this is a string. Thank you. You solved my problem (as stupid as it was -which most of mine are!)

Again I really appreciate you all taking time to help me.

 

[Pat Hartman]

The strange thing to me is that the number is formatted correctly in the underlying table so I don't understand why the zeros are being stripped

NEVER add formatting at the table level. All it does is to obfuscate the stored data.

If this is a code field where leading zeros are significant as they are with New England Zip codes "06360", then the field should be defined as text. No formatting will be required.