grovduck
asked on
Can I wrap field names in a query in Access 2003?
Is it possible to wrap field names in a query in Access 2003? Someone asked this question about Access 2000, and the answer was no, so I suspect the answer is still no.
However, the alternative suggested was "Use a form or report with a field property of CanGrow = Yes." So I tried this on a form and on a report, but the field names still do not wrap. I think there is some other piece of information that I am missing to make this approach work - does anyone know what that might be? Thanks.
However, the alternative suggested was "Use a form or report with a field property of CanGrow = Yes." So I tried this on a form and on a report, but the field names still do not wrap. I think there is some other piece of information that I am missing to make this approach work - does anyone know what that might be? Thanks.
Can you provide an example of what you mean? Where do you want the fields names wrapped?
ASKER
Sure thing. We have some fields in our db that have long names even though they're already abbreviated, e.g PLANT_ASSOC_CODE. In Excel I could change the height of the first row and enable wrapping to make the names look like this:
PLANT_
ASSOC_
CODE
That way I can still see the entire name of the field, and I can also get more fields to fit on the screen. I just want to know if there is a way to do that in Access.
PLANT_
ASSOC_
CODE
That way I can still see the entire name of the field, and I can also get more fields to fit on the screen. I just want to know if there is a way to do that in Access.
I will have to check this out, I would think based on the length of the field you should be able to adjust the height of the label that the field name is filling.
Then the issue how to handle the '_'.
I will play will this at home tonight and see if its possible.
Then the issue how to handle the '_'.
I will play will this at home tonight and see if its possible.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
or are you talking about Datasheet view (like an excel table)?
I've been doing some reading on this and if your talking about the gray-area in the datasheet the I believe that the answer is sadly "No". However, if your talking about a continous form then there maybe some flexiblity there, but it will not work like a table from Excel.
ASKER
Thanks for the info on captions Imoutwest and harfang.
Imoutwest,
Yes, I did want the names to wrap in datasheet view, but it sounds like I would have to create a form or report instead. Our database is split with the back end on SQL Server and the front end in Access. So I have created a bunch of queries (views) in SQL Server that I link to in Access. These views are listed in the tables tab in Access, and I would like to avoid having to create reports for each view. So I guess I will either live with the long field names or decide to create reports.
Thanks to both of you for telling me how to wrap the names in forms and reports.
Imoutwest,
Yes, I did want the names to wrap in datasheet view, but it sounds like I would have to create a form or report instead. Our database is split with the back end on SQL Server and the front end in Access. So I have created a bunch of queries (views) in SQL Server that I link to in Access. These views are listed in the tables tab in Access, and I would like to avoid having to create reports for each view. So I guess I will either live with the long field names or decide to create reports.
Thanks to both of you for telling me how to wrap the names in forms and reports.