Advice on achieving a dynamic page of text in access

[Tim F]

Hi all,

I am hoping someone can give me a starting point for what I want to achieve. I have a working knowledge of access and VB but I am a recent learner so there's probably a lot of things that I don't even know exist.

I want to create a 'checklist' on a form. The user fills in the checkboxes and then presses a button. Pressing the button launches a popup form with various pieces of text displayed, based on how the checklist was completed.

If it helps to put this in perspective, the user will be working through a customer record with the checklist and then generating a custom talk script based on what they noted in the record.

All easy enough so far, I have a prototype that works by setting visible to true/false for the various text areas (labels) in the popup form, based on values in the checklist. But is there a way, where a text item is hidden, for lower items to 'move up' the page? As it is now, users have to scroll down large blank areas on the page where a large text item is hidden in order to get to the next visible item.

In a way I'm not sure that access is the best application for this task but I already have a lot of other code written in the database which I need to do the record checks in another system, so if anyone has advice on how to achieve this it would be greatly appreciated :)

[ADezii]

Do these Text Boxes have Control Sources, or are they use for displaying Text only depending on prior selections from a List? What are the Maximum Number of Text Boxes that can actually be displayed? What, exactly needs to be displayed. Kindly provide more detail, along with relevant code, so that we may proceed.

[MOCaseA]

From what I'm seing building a custom report based on a query is what you are looking for.

Create a query with all the needed fields as options (any fields that you need that aren't yes/no need to be in here as well)
Set the criteria in each Yes/No field as Yes (type it in). I would recommend not showing the Yes/No field unless you want a ton of "Yes" entries on your report.
Build a report based on the query and only those entries selected as yes will show.
You will probably have to tweak the report to show the neccessary dialog, but with a simple query you can eliminate a lot of empty space on your report.

If you already have a query built (the one generating a lot of space) you can run this query as well after that one to clear out the extra space.