A access2010 Registered User. Local time Today, 13:32 Joined Dec 26, 2009 Messages 1,115 Mar 20, 2016 #1 Hello we are using MS Access 2003 and would like to expand our comments field without using Shift + F2 Could I please receive the code on how to accomplish this Thank you Wendy Attachments Expand_Comments_Field.mdb Expand_Comments_Field.mdb 208 KB · Views: 57
Hello we are using MS Access 2003 and would like to expand our comments field without using Shift + F2 Could I please receive the code on how to accomplish this Thank you Wendy
C CJ_London Super Moderator Staff member Local time Today, 21:32 Joined Feb 19, 2013 Messages 17,447 Mar 20, 2016 #2 perhaps something like Code: Private Sub myComments_GotFocus() myComments.height=myComments.height*4 End Sub Private Sub myComments_LostFocus() myComments.height=myComments.height/4 End Sub change the name of myComments to the name of your comments control
perhaps something like Code: Private Sub myComments_GotFocus() myComments.height=myComments.height*4 End Sub Private Sub myComments_LostFocus() myComments.height=myComments.height/4 End Sub change the name of myComments to the name of your comments control
missinglinq AWF VIP Local time Today, 16:32 Joined Jun 20, 2003 Messages 6,420 Mar 20, 2016 #3 Or simply Code: Private Sub myComments_GotFocus() DoCmd.RunCommand acCmdZoomBox End Sub But I like CJ's approach in that you can adjust the size to suit your needs by changing the factor of 4 to something else! Linq ;0)>
Or simply Code: Private Sub myComments_GotFocus() DoCmd.RunCommand acCmdZoomBox End Sub But I like CJ's approach in that you can adjust the size to suit your needs by changing the factor of 4 to something else! Linq ;0)>