Unanswered: Need help in setting up a default value for a field
I am trying to set a default value for a text box to '01' in the properties of the textbox.
But, no matter what I choose the datatype for the field, either 'Text' or 'Number' it keep changing to '1'. I even tried setting the default value by VBA, then also, it is changing to '1', and for my requirement, I need the zero as well in front of '1'.
The VBA code I wrote as:
Private Sub Form_Open(Cancel As Integer)
txtClinicNum.DefaultValue = "01"
How can I achieve this. any idea or help is greatly appreciated.
Originally posted by agduga
I have access 2000 and if you right click on the textbox and go to the Format tab or the All tab, there is an item called format where you can select Fixed from the drop-down menu