Results 1 to 2 of 2
  1. #1
    Overdive is offline Novice
    Windows 7 Access 2007
    Join Date
    Oct 2009
    Posts
    9

    Unbound Text box in reports

    Hello



    I am generating a report from a form with no problem.
    However I added an unbound textbox to the report (in design view). Basically the textbox is to serve as comment from the users but every time I type, the text disappears... Is there a way to have unbound textbox so user can type on the report before printing? or is it just not possible in Access?


    Thank you

  2. #2
    Jamy is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    36
    One way to do this is to make a form (dialog) with the textbox. The control source of the textbox on your report should be: =Forms![name form]![name control on form].

    Make sure that the form isn't closed, so make the VBA or macro to set the form to visible. VBA: Forms![name form].visible = false Macro: Setvalue, visible, no.

    Good luck!

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

Similar Threads

  1. Use unbound boxes in a form
    By jjerome512 in forum Forms
    Replies: 2
    Last Post: 01-14-2010, 08:53 PM
  2. Bound a unbound text box to the table
    By Brian62 in forum Forms
    Replies: 1
    Last Post: 11-06-2009, 11:05 AM
  3. Transfer Text to Unbound Form
    By DWS in forum Forms
    Replies: 3
    Last Post: 08-25-2009, 08:04 AM
  4. Get average of unbound textboxes.
    By markhook in forum Forms
    Replies: 8
    Last Post: 07-14-2006, 09:30 AM
  5. Unbound text box truncating text
    By gddrew in forum Forms
    Replies: 0
    Last Post: 03-02-2006, 11:26 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