Transferring Padded Zeroes from Access Form to Access Table

[Sarahsedaii]

We use company numbers to identify what we are working on (example Claims, Inc. is 0100). We always use 4 digits, and sometimes they are padded with zeroes. When I am inputting new lines into the database via the form, I will type in the company number – 0095, but it is added to the table as 95. The table has this field formatted as a string. I can enter straight into the table with 0095, and it will hold. On the form the textbox converted to a string after the textbox is updated. Where am I going wrong?



I even tried using a combo box with a query only having the correctly formatted company numbers, but it still gets added to the table without the padded zeroes.

Thank you!

[ssanfu]

There is a difference between formatting and a field being defined as a text field.

In design view of the table, is the field type "Text"?

If it is, then there must be something about the text box. Is there any event code for the text box?

Maybe delete the text box from the form, save the form and re-add the text box using "Add From Existing Fields" (in the Design menu). Re-name the text box by adding "txt" to the front of the name.

[JoeM]

When I am inputting new lines into the database via the form, I will type in the company number – 0095, but it is added to the table as 95.

Is your TextBox on your Form bound directly to the underlying Table field? It does not sound like it. What is the Control Source of the Text Box?
How is the TextBox formatted?
Is there VBA code or something else that writes the value from the Text Box to the underlying table?