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

Typically, I never use them because of query issues, but in this case I want
them. I'm trying to do some tricky things. 

Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, May 20, 2008 9:43 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Query Column Headings -Table's Caption PropertyVs a
Query's Alias

Hi John

I didn't know that, but actually it is explained in the on-line help of
Access 97.

Morale: Don't set Caption for fields of tables/queries which are going to be
used as the source for a query where you need custom captions.

/gustav

>>> askolits at nni.com 20-05-2008 15:27 >>>
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