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

Yes, that's it!

And I can do it programmatically!

Dim qryDef As DAO.QueryDef
Set qryDef = CurrentDb().QueryDefs("qrySearchResults")
qrydef.fields("strLastName ").Properties("Caption")="The Last Name Of The
Person Is"
qryDef.close

Thanks!




-----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:50 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query Column Headings -Table'sCaption PropertyVs
aQuery's Alias

By manually, I meant the query column's property -- right-click the column, 
choose Properties. You can enter "The Last Name..." string as the query 
column's Caption property to override the table's.

Susan H.




> 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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 

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