By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,148 Members | 765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,148 IT Pros & Developers. It's quick & easy.

How to text wrap header field in Access 2007 table

P: 33
Hey guys - Is there a way to wrap the text in the header field in an Access 2007 table. I did some googling, however no luck, thought I will post it here. I sure appreciate your time and help.

stan
Feb 5 '10 #1
Share this Question
Share on Google+
6 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
You set the CanGrow of the Textbox to True


EDIT: Sorry, didn't read properly, that you were indicating it was in a table.
Feb 5 '10 #2

missinglinq
Expert 2.5K+
P: 3,532
Why would you want to do this in a table? The table should never been seen by end users; data should be displayed via a form.

Linq ;0)>
Feb 5 '10 #3

P: 33
I agree. Sometimes as an admin, when I go through the table, some of the header fields are so long and the pertinent part differentiating one field from the other is almost towards the end and is hidden....and that is so frustrating. So I was just checking if there was a way to wrap the text. Well it seems like there is no way we can do this.
I will go ahead and close the post after some. Thanks Smileyone and Missinlinq for your time and checking my post. Appreciate it...

stan
Feb 5 '10 #4

NeoPa
Expert Mod 15k+
P: 31,494
I can see why you might want to Stan, but I don't think there is a way. I assume you're talking about wrapping the name of the field itself when displaying the table in Table View.
Feb 5 '10 #5

missinglinq
Expert 2.5K+
P: 3,532
And the real bottom line, here, is that even as admin you really shouldn't be looking at your data in table view, unless you're doing some kind of trouble-shooting, such as verifying that data is appearing in the table. And as the developer, you really should know what a field name is even if you cannot see all of it.

Tables are not really intended to display data, which is why they don't have all the formatting options available like a form does. Most experienced Access developers will tell you that tables are simply buckets or containers for holding data, and holding it in no particular order.

Linq ;0)>
Feb 5 '10 #6

P: 33
I agree Missinglinq; the admin should know their table fields well; ...i just created this database recently and there's a bunch of fields and as a newbie to the database itself, gets confusing...so anyways..no biggie...

Yes Neopa, I was talking about the name of the field itself when displaying in the table view.

Well, I am getting ready to post another issue here that has blocked my progress.

Thanks guys!! This is a great place and am learning a lot by mere reading some of the older posts.

Stan
Feb 6 '10 #7

Post your reply

Sign in to post your reply or Sign up for a free account.