Hello,

I have a query that uses some OLD data that needs to be cleaned up for a report. My report is based of a query that contains this data like BillToCustomerName, Address, Contact. I want to trim spaces, convert some of the fields to proper case and clean up some for display purposes.

If I don't put a field from the query on the form how can I use it in code behind the form. I've tried things like strTemp= Me![CustomerBillToName] but then I get error that Access can't find that field.

Do I have to put it on the form and then hide it or is there another way. This is just a quick fix until we can port all the data over and fix it once and for all.

Thanks.
David