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

text Field "can grow" property

P: 11
Is it possible in a form while entering data in a text field to get the field to drop down so as to see all of what you're typing. I know this option is available in a Report but haven't come across any information about it regarding forms?

Regards,

Steve
Mar 27 '07 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
There is no "can grow" equivalent for forms. One work around is to allow the user to use the ZoomBox command to expand the text box for data entry/viewing. The best way is probably by using the DoubleClick event:

Expand|Select|Wrap|Line Numbers
  1. Private Sub YourTextBox_DblClick(Cancel As Integer)
  2.    DoCmd.RunCommand acCmdZoomBox
  3. End Sub
The drawback to this method is that the zoombox is large and awkward and you can't control where it pops up. Give it a try, and if you feel it's too unwieldly, post back and I'll give you a work around that requires a bit more work but one where you can control the size/placement of a custom zoom box.
Mar 27 '07 #2

P: 11
There is no "can grow" equivalent for forms. One work around is to allow the user to use the ZoomBox command to expand the text box for data entry/viewing. The best way is probably by using the DoubleClick event:

Expand|Select|Wrap|Line Numbers
  1. Private Sub YourTextBox_DblClick(Cancel As Integer)
  2.    DoCmd.RunCommand acCmdZoomBox
  3. End Sub
The drawback to this method is that the zoombox is large and awkward and you can't control where it pops up. Give it a try, and if you feel it's too unwieldly, post back and I'll give you a work around that requires a bit more work but one where you can control the size/placement of a custom zoom box.

Thanks missinglinq,

I'll give it a go.

regards,

Steve
Mar 27 '07 #3

Post your reply

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