Incorrect display in Query

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I am using access 2002 with 2000 file type.
I have an append query which adds a record based on the
fields in a form. This operates correctly but if i
display the datasheet view of the query I get a foreign
symbol shown instead of a long integer field and a blank
shown instead of a date. A select query does the same.

eg
expr1: forms![FormName]![FieldName]

Any ideas hve you senn this can it be fixed?
 
The problem may be that Access does not understand the data type you intend.

If the text box is unbound, set its Format property to General Number or
Short Date so Access knows the intended type.

You can also use the type conversion functions such as CLng() or CVDate() in
the calculated field of your query. Details in article:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
 
Back
Top