Conditional formatting in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hopefully I can explain this well enough to drum up some ideas out there.
Thanks way in advance if you can offer me any help.

I have a subform in a form that displays the many side of the information.
The subform contains many rows and columns of information. I have it set up
so that if the user wants to put a memo in a certain field, in a record, in
the subform, they can double click that field and it opens a small pop up
form for them to enter in information for that particular field/record. The
whole system works well except for one thing. There is no way for the user
to know what field/records have memos in them. I do have a button on the
main form that they can click on and it shows them ALL the memos behind the
subform. What I would like to do is have a visual. I would like to put some
sort of conditional formatting that says if this field/record memo is not
null, them make that "cell" a different color. Then the user can double
click on the field to see the memo.

Any ideas?
Thanks!
 
AT,

Do you mean you have a textbox on the subform bound to the memo field?
Try applying Conditional Formatting to that control, based on:
Expression is [YourMemoField] Is Not Null
 
Thanks for your help, that worked.

Steve Schapel said:
AT,

Do you mean you have a textbox on the subform bound to the memo field?
Try applying Conditional Formatting to that control, based on:
Expression is [YourMemoField] Is Not Null

--
Steve Schapel, Microsoft Access MVP

Hopefully I can explain this well enough to drum up some ideas out there.
Thanks way in advance if you can offer me any help.

I have a subform in a form that displays the many side of the information.
The subform contains many rows and columns of information. I have it set up
so that if the user wants to put a memo in a certain field, in a record, in
the subform, they can double click that field and it opens a small pop up
form for them to enter in information for that particular field/record. The
whole system works well except for one thing. There is no way for the user
to know what field/records have memos in them. I do have a button on the
main form that they can click on and it shows them ALL the memos behind the
subform. What I would like to do is have a visual. I would like to put some
sort of conditional formatting that says if this field/record memo is not
null, them make that "cell" a different color. Then the user can double
click on the field to see the memo.

Any ideas?
Thanks!
Click to expand...
Click to expand...
 
Back
Top