Results 1 to 3 of 3
  1. #1
    Whizbang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    37

    Is it possible to use a subform on a report for entry?


    I am attempting to design a database for surveys. Some user will create a survey with however many questions they want. Then other users will answer thos questions. What I would like to do is to take advantage of the ability of report fields to grow, and have the questions be in a report, with a subform for each question to allow the user to enter the answer. I could easily do this in a form, but form fields do not grow/shrink with the text contained therein. I would like the user to be able to just scroll down and read all the questions in one long form, and have a spot on each question to fill in the answer.

    Thoughts/suggestions?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,644
    Cannot do data entry/edit on reports, even if the subreport is a form object.
    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
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    One feature you could look into is the ZoomBox. There are several ways of implementing it - use the advanced search feature of this forum and search for zoombox, you'll get lots of ideas.

    The idea here is that you could present your survey questions with a moderately sized text box for the answers, but if the users wanted a bigger box to put longer answers in (and still see most or all of their text), they could for example double-click on the smaller text box to "Zoom" to the bigger one.

    Click this for the advanced search: https://www.accessforums.net/search.php?search_type=1

    HTH

    John

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

Similar Threads

  1. Capturing Latest Entry on Subform
    By Marie1106 in forum Forms
    Replies: 3
    Last Post: 02-21-2012, 10:40 AM
  2. Disable new entry in subform
    By mdewell in forum Forms
    Replies: 3
    Last Post: 01-05-2012, 02:38 PM
  3. Replies: 7
    Last Post: 07-15-2011, 01:58 PM
  4. Data Entry in SUBFORM
    By flsticks in forum Access
    Replies: 1
    Last Post: 04-03-2011, 08:07 AM
  5. Entry into subform
    By lynchoftawa in forum Forms
    Replies: 1
    Last Post: 06-17-2009, 09:28 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