How can I set "0630001" as the default value for a field?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I want to set a default value for a field in a table. The field's data type
is text. I want the default value to be '0630001'. However, when I enter
that value in the field proprties list, it is automatically converted to
'630001'.

How can I set 0630001 as the default value without having the leading zero
truncated?
 
You must log in or register to reply here.

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

Similar Threads

change default value in table field - Easy for user 4
Access how do you set a yes/no data type as required? 0
default value based on an expression within the table 2
Default Value as last date in a table? 5
Default Value in Table 2
Expression as default field value 1
How do I set the same default values on all fields in a table? 7
default value +1 by default 3

Back
Top