default values in a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I want to have "000" in a text field as default if someone doesn't enter
a text or a number in that field. The field is a text field and allows only 3
characters in it. I would like for it to default to three zeros. I tried and
it only allows me to put on zero as a default. How do I do this?

jac007
 
jac007 said:
Hi, I want to have "000" in a text field as default if someone
doesn't enter a text or a number in that field. The field is a text
field and allows only 3 characters in it. I would like for it to
default to three zeros. I tried and it only allows me to put on zero
as a default. How do I do this?

jac007

Since it's a Text field you need to put quotes around the default value "000".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top