Access in Office 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top