[AccessD] Query Column Headings -Table's Caption PropertyVs aQuery's Alias

Manually is fine but it always defaults to the string that's in the caption
property.

So if in the table's design I have: (Ignore all quotes)
FieldName: "strLastName"
Caption: "Last Name"

And create a query that has the following alias in the field grid:

"The Last Name Of The Person Is:strLastName"

You would think after running the query the column heading would be "The
Last Name Of The Person Is".

But it's not. The alias is ignored and it defaults to the value in the
caption property within the table's design.





-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, May 20, 2008 9:06 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query Column Headings -Table's Caption PropertyVs
aQuery's Alias



> When using a query, I want an alternate column heading to what's provided 
> in
> the field's caption property located in the table's design.

=====Can you set it manually in the query design window, or must you do it 
on the fly with code?

Susan H.

>
> You can do it manually in the query design window. Does that help?
>
> Susan H.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com