View Full Version : Getting Default Value to Stick


LynnEsther
05-02-2008, 10:53 AM
Hello. I have a field defined as text called InvoiceNo. I want the default value to be 00-0000. However, 00-0000 converts itself to 0-0 when I save the field properties. What am I doing wrong? TIA. :confused:

KenHigg
05-02-2008, 11:13 AM
What data type is it?

RuralGuy
05-02-2008, 11:15 AM
Have you tried using quotes "00-0000"?

LynnEsther
05-02-2008, 11:21 AM
The quotes worked (it is a text data type). Heel of hand slapping forehead. I should have known this. Sorry...it's Friday (that's my excuse). Thanks a million! :D

RuralGuy
05-02-2008, 11:28 AM
Glad I could help. Have a great weekend.