Results 1 to 6 of 6
  1. #1
    cowboy is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jan 2010
    Posts
    291

    Inputting to txtbox is making subform have scrollbars

    Not sure what is causing this to happen but I have a form that I input a value into a text box (txtItemMarkup) and a subform query that the query uses the value from txtItemMarkup in one of its equations is; Markup: [Price]*[txtItemMarkup] which works fine.



    Problem: When I put info into txtItemMarkup it adds scroll bars to my subform.

    on the subform properties I have scroll bars set to neither, is there another setting I need to look at? I have attached a picture to help see the problem easier. (txtItemMarkup) is the box with the 2 in it in the second picture. Thanks for help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,601
    Not sure why.

    The Markup field looks wider than necessary. Surely doesn't need to be wider than the Price field. Try resizing it.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cowboy is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jan 2010
    Posts
    291
    I made the Markup field big so I could be sure that it wasnt a size issue. I was thinking there may have been a setting I set wrong, is the subform scrollbar set to neither the only setting I need to worry about?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,601
    I don't understand why this is happening. Wouldn't you want the vertical scroll bar? If you want to provide project, will look at.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Just make the subform control a little bit bigger (wider, actually) on the main form.
    Last edited by boblarson; 09-29-2011 at 03:22 PM. Reason: add info

  6. #6
    cowboy is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jan 2010
    Posts
    291
    that works, but it is not visually pleasing, I guess thats the best I can do.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Scrollbars on a sub form
    By Paul H in forum Access
    Replies: 3
    Last Post: 09-12-2011, 01:26 PM
  2. Replies: 0
    Last Post: 02-27-2011, 04:21 PM
  3. Making subform field visible/invisible
    By Snufflz in forum Forms
    Replies: 3
    Last Post: 01-17-2011, 05:30 AM
  4. Inputting Free text in Form
    By maintt in forum Forms
    Replies: 2
    Last Post: 08-13-2010, 11:43 AM
  5. Replies: 15
    Last Post: 02-16-2010, 10:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums