HELP! Query output autoformats number in text format as dates

[Goose]

I have a table with a series of ID's which I need to keep in text format. The ID's look something like this in the table:

201111464


201111474
201111491

When I run a query to find duplicates, the query outputs the same ID's in this format:

12/1/2002
12/1/2002
12/1/2003

it's autoformatting them into dates, how can I stop this?

[ItsMe]

What is the data type of the field in the table? What is your SQL for the SELECT query?

[Goose]

Data type is TEXT the SQL is simple:

SELECT UniqueID_MASTER.[UniqueID], UniqueID_MASTER.[PCClassification], UniqueID_MASTER.[dataid]
FROM UniqueID_MASTER
WHERE (((UniqueID_MASTER.[UniqueID]) In (SELECT [UniqueID] FROM [UniqueID_MASTER] As Tmp GROUP BY [UniqueID] HAVING Count(*)>1 )))
ORDER BY UniqueID_MASTER.[UniqueID];

[June7]

I am confused. Why would UniqueID have multiple records in UniqueID_Master?

I don't see anything in query to cause this issue.

If you want to provide db for analysis, follow instructions at bottom of my post.

[ItsMe]

June's correct. So far, there is not a reason for the symptom you describe. You must be looking at a textbox control that is formatted as Date. Perhaps create a new textbox control and then bind it to your dataid field, without formatting.

[Bob Fitz]

Could this be caused by corruption. I can't see how the numeric data in OP can be changed to date values in the OP

[John_G]

Did you check the format of that column in the query design? Right-click the column, then select Properties (that is for A2003 - A2010 might be different). What is the Format set to?

John