Mar 23 2005, 03:34 PM
I have some permanent queries in place from a dropdown and table on my form. My question is some of the Field names in the Query are big (wide). I know the Field Names come from the Field Names of the Table, but is there any way to change the field names on the Query manually so they can be shortened. In other words cheat the system.
Thanks in Advance!
Mar 23 2005, 03:38 PM
Use an alias. In the top row of your query column put something like this:
Short Name: TheActualLongNameOfYourFieldGoes Here
Now you wil see Short Name in the query or wherever you use the query as a Row or Record Source.
Mar 23 2005, 03:59 PM
You could also use the Caption property for those fields in Table design.
Mar 23 2005, 04:43 PM
In the query design screen select properties and click on the field column.
You will the be able to set the caption property for that field in that query.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here