Can't change captions in a totals query.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have made a totals query as a source for a list box on an invoice form.

All works well, but when I try to change the captions via the 'properties'
in the query columns (and therefore for the list box), one column refuses
to be renamed though the others rename OK.

Why is one column refusing to be renamed. Please help, Frank
 
I would use aliases in the row source query:
Select EmpID as ID, EmpLastName as [Last Name], EmpFirstName as [First
Name]...
 
I have made a totals query as a source for a list box on an invoice form.

All works well, but when I try to change the captions via the 'properties'
in the query columns (and therefore for the list box), one column refuses
to be renamed though the others rename OK.

Why is one column refusing to be renamed. Please help, Frank
Click to expand...

My memory on this may be faulty, but check field's Caption property in
the underlying table. If that field has a caption, that will over-ride
whatever you do in the query.
 
Back
Top