Stop access from changing format/value of data entered from a form, into a table.

[Mattbro]

Hello,
I have a database (split into front and backend). Users populate the table using a form on the front end. Recently, it has been pointed out that some of the data entered into one specific textbox is being changed on the table. The data entered is always has a minimum of a letter and number value i.e. "A1", "A2" etc. Upon examining the table, this has changed into numeric values i.e. "1291", "1061", "852"... etc. Looks like it is translating them into both 3 and 4 digit numerical values by the looks of things. Where more complex data is entered such as "2(A1, A2)" these seem unaffected.

The field is set to text, I have set no validation rule, format or input mask. Just can't see why access is changing these values. It seems to be translating them, but I can't see a pattern. Does anyone have an idea what is happening here?
Many thanks,


Mattbro

[rpeare]

Are you using a bound or unbound form? If you're using an unbound form the procedure appending the records to your table may be in error (looking at the wrong field on your form). This happens mostly when you're attempting to perform an operation on a date field (dates handled as text or numbers by accident). If that fails can you provide a sample of your database (make a copy of your db, strip out any confidential information, compact/repair and upload a zipped file of it to this site) and I can take a look.

[Mattbro]

Ah-yes I think I see. Looking at your post, I have gone back to the form, looked at the textbox properties and noticed that the data row source has changed. This would account for it, but it is odd that this has suddenly happened-access doesn't tend to corrupt, does it? Perhaps I should lock the properties of the form to ensure noboby has been 'playing with it'! THanks for your help,
Mattbro