Checking values on a continuous form

[Magster]

Hi all,

I wanted an easy visual way to let my user know if their memo field has any data in it without clicking a button.

I created a single form with a button that calls a modal dialog form where I allow the users to edit a memo field which is contained in the underlying query of the single form. I then created a label field containing an asterisk that I want to be visible when the memo field has data, and invisible when it doesn't. I check the memo field on form current and after form update, and it is slick on the single form.

Any suggestions on how I accomplish the same on a continuous form?

 

[gemma-the-husky]

have a check box, with control source

=iif(nz(mymemo,"")<>"",true,false)

will give you a tick if there is data in the memo field

 

[Magster]

Thanks for your reply - and that does work great... however, my question is centered more on how to accomplish this on a continuous form.

The continuous form displays a check (in your example) on every detail line as long as one of the detail line has something in the memo. There must be a work-around to only display the check on the rows that have a memo.

Thanks again! Anyone else have a suggestion?

 

[Rich]

Gemma's example will work on a continuous form, here's something very similar

 

[Magster]

Thanks for the reply - I looked at the example you sent and I don't see the connection because the check field on the form is a field in the table. There must be another way to do this... am I missing your point?

 

[Rich]

The check field is an unbound textbox, it is not a field in the table

 

[Brianwarnock]

The check field is an unbound textbox, it is not a field in the table

I wonder if you can help me out here Rich because I think its an unbound Checkbox not textbox, but maybe my terminology is incorrect.

nice solution, what level Access ?

Brian

 

[Magster]

I having it working now....

I added an unbound check box and in the control source I put: =IIf(IsNull([memDetailNotes]),False,True); I set enabled to false and locked to yes.

thanks!