Change column name display....?

[Guest]

Hi,
I thought allI had to do is add a "Name:" in front of a
column in my query to change the column title display. teh
strange thig is that it works in some cases, but not
all ?!? I have not found any logic either to determine why
it does or does not work. Can anyone help?

Thanks a lot

 

[RobFMS]

I don't make the changes via the QBE but if you make a change in the SQL
string and then look at the QBE then you'll see how it works.

Do any of your columns headers have spaces between them? Make sure you use
brackets. For example:

Select Field1, Field2, Field3
From Table1

.... can be transformed to....

Select Field1 as [First Name], Field2 as [Middle Name], Field3 as [Last
Name]
From Table1

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[John Spencer (MVP)]

IF you have the column's Caption property set in the grid, then the CAPTION will
show up on the Datasheet view. Also, if your field in the table has a caption
property, that will show up as the column title on the Datasheet view in place
of the fieldname or the alias for the field.