Display text boxes, based on tests selected

rowardHoark

Registered User.
Local time
Today, 06:29
Joined
Jan 14, 2011
Messages
20
My report needs to display test results. Different reports have different tests conducted.

Initially I was thinking of using text boxes with visibility based on/off test selected.

XXXXXXXXXXXXXX (test 1 selected)
XXXXXXXXXXXXXX (test 2 selected)
XXXXXXXXXXXXXX (test 3 selected)
XXXXXXXXXXXXXX (test 4 selected)
XXXXXXXXXXXXXX (test 5 selected)

However I encounter a problem of gaps in my report.

XXXXXXXXXXXXXX (test 1 selected)
..........................(test 2 not selected)
XXXXXXXXXXXXXX (test 3 selected)
XXXXXXXXXXXXXX (test 4 selected)
XXXXXXXXXXXXXX (test 5 selected)

I would like to find a way to avoid this and have something like this:

XXXXXXXXXXXXXX (test 1 selected)
XXXXXXXXXXXXXX (test 3 selected)
XXXXXXXXXXXXXX (test 4 selected)
XXXXXXXXXXXXXX (test 5 selected)
 
What does "test 2 not selected" mean? If you don't want test 2 showing then you need to filter it off in the record source of the report.

Perhaps you want to use Not Is Null in the criteria.
 
What does "test 2 not selected" mean? If you don't want test 2 showing then you need to filter it off in the record source of the report.

Perhaps you want to use Not Is Null in the criteria.

Ok, let's say I filter out a particular empty test (toggle off) from the record source. How do I then display the tests conducted (toggle on)? Write a VBA to create text boxes for results of those tests?
 
Have you set the can grow/shrink properties on the text boxes?
 
Ok, let's say I filter out a particular empty test (toggle off) from the record source. How do I then display the tests conducted (toggle on)? Write a VBA to create text boxes for results of those tests?
You can set the criteria to only show Toggle ON. I don't know what sort of records you have but it will be simple enough to write the criteria.
 
Although it works, I don't see the Can Shrink property as the most optimum way to handle this since it's doing it on the fly.

Perhaps the difference won't be noticed if you have a relatively small set of records.
 

Users who are viewing this thread

Back
Top Bottom