Access in Office 2003

A

Angela Coventry

I have update my client listing in access and when I print off the report is
shows 'error' in the contacts first names - is there a way of changing this
so that the first names are listed in my report
 
J

Jerry Whittle

Hi,

Open up the report in Design View. Right click on the First Name text box.
Bring up the Properties. At the top of the All tab, what does it say for the
Name and Control Source? Does the Control Source match a field in the table
or query that drives the report?

Could the First Name text box have something like the following in it?
=UCase([First Name])

If so it is not a recognized function, has the wrong arguments, you have a
references problem, or the Name of the text box is the same the field in the
Control Source. The last is a very common problem. It that case, change the
name of the text box to something slightly different like txtFirstName.

By default Access uses the name of the control source for the name of the
text box control. Works great until you start messing with things then Access
gets confused and shows errors. I usually change all my text box names by
adding txt, dt, num to them so as to prevent such errors.
 
Top