Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    When I click a text box control of a memo field, how to pop up a form so that I can plenty of room to edit a lengthy memo?
    Can I do it in macro only? How? Can you show me the technique with a sample accdb?
    Thanks a lot.

    Armstrong
    Attached Images Attached Images

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts
    RunCommand - ZoomBox is the macro you want.

    I would attach it to the double-click event of the textbox not the click event otherwise it will become a pain for users.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='SteveH' post='774431' date='09-May-2009 18:39']RunCommand - ZoomBox is the macro you want.

    I would attach it to the double-click event of the textbox not the click event otherwise it will become a pain for users.[/quote]
    Steve,
    Thanks for your tips. In fact it works brilliantly. It's amazingly simple to learn thanks to your help.
    Thanks again.
    Armstrong

  4. #4
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Steve,
    The embedded macro is unnecessary.
    Just press Shift+F2 to attain the same result.
    Armstrong

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •