Post the SQL of the query or form source.
--
Build a little, test a little.
What is the Recordsource property of the form? If it's a query which does not
include the fields, or the fields are in some other table, you'll get this
effect.
You may also be having a problem if these are Lookup Fields, which appear to
contain text but actually contain concealed numeric links.
--
John W. Vinson [MVP]