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.