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

John,

Right you are.  I very seldom use the Caption property in my table
designs.  Much more frequently I'll use the Description field.

The solution, I'm afraid, is to restructure the tables to get rid of
the Caption properties.

Steve Erbach
Neenah, WI


On Tue, May 20, 2008 at 8:27 AM, John Skolits <askolits at nni.com> wrote:
> 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.