Continuous Form issues

R

reeve13

I am working in a continuous form containing over 8,000 records, an
within the form, I have a field named “comments” which I used th
“zoom,” “on click,” and “toggle button.” The problem I am facing is
not all of the records contain comments, and I need a way to indicat
to others upon viewing a record that there is additional information i
the comments field behind the toggle button. Any suggestions on how t
show/indicate when a comment is left so the individual can click on th
toggle button to view the comments? I was told when using a continuou
form, it mimics the command for all records and I need a way aroun
this.

Thanks
 
A

Allen Browne

You want a visual indicater as to whether the Comments field has contents?

Add a text box with these properties:
Control Source: =([Comments] Is Not Null)
Font Name: WingDings
Format: "";÷

Use whatever charater suits you. The one I suggested is a finger pointing
down the the Form Footer section where you can fit the comments box for the
current row. To get that, type 2 double-quote marks into the Format box,
followed by a semicolon. Then hold down the Alt key while typing 0247 on the
numeric keypad.

Presumably you are using Shift+F2 to get the zoom box. I'm not clear why you
would use a toggle button (rather than a command button.)
 
J

John Vinson

I am working in a continuous form containing over 8,000 records, and
within the form, I have a field named “comments” which I used the
“zoom,” “on click,” and “toggle button.” The problem I am facing is,
not all of the records contain comments, and I need a way to indicate
to others upon viewing a record that there is additional information in
the comments field behind the toggle button. Any suggestions on how to
show/indicate when a comment is left so the individual can click on the
toggle button to view the comments? I was told when using a continuous
form, it mimics the command for all records and I need a way around
this.

Thanks.
Click to expand...

I'd suggest a textbox based on a calculated field in the Query upon
which the subform is based:

=IIF(IsNull([Comments], "", "See Comments")


John W. Vinson[MVP]
 
Top