Problems with Conditional Formatting

[nickaccess]

Todays test, here goes

I am trying to get my format to say if the field is empty (no date) I want you to show the word Invalid. I can get the colour to come up but not the word. At the moment it looks like this.

Expression is IsNull([DATEAPVAL])=True

At the moment the colour is BLUE and that is fine but I want the word to appear if no date is present in the field DATEAPVAL.

Thank you everyone as always, remember this old dog IS learning new tricks with the help of this group.

 

[isladogs]

Yours should work but try this instead:

Expression Is Nz([DATEAPVAL],"")=""

In either case, the CF may not work in all form views UNLESS you click on the field

 

[nickaccess]

Yours should work but try this instead:

Expression Is Nz([DATEAPVAL],"")=""

In either case, the CF may not work in all form views UNLESS you click on the field

Sorry, another one that will not work. Once I can do screen shots etc maybe that will help. Thank you again.

 

[isladogs]

I tried both versions & they worked for me in datasheet view
However in Form View both worked ONLY if I clicked on them

By comparison, this kind of thing works fine in Form view:

You can also see the field with blanks that I used to test earlier

 

[nickaccess]

I tried both versions & they worked for me in datasheet view
However in Form View both worked ONLY if I clicked on them

By comparison, this kind of thing works fine in Form view:

You can also see the field with blanks that I used to test earlier

System has now crashed hahaha, just my luck. Will try next week. Thank you as always. Nick

 

[nickaccess]

System has now crashed hahaha, just my luck. Will try next week. Thank you as always. Nick

I have looked again today. I can get the field to colour blue but I still cannot get it to read INVALID if the field is empty. The Nz bit definitely does not work at all. I bet you guys are pulling your hair out hahaha.

Any other suggestions??? Apart from go away

 

[Galaxiom]

Easiest way to show text instead of a value is with the Format property of the control.

;;;"Invalid"

You can also set the foreground colour.

;;;"Invalid"[Red]

The semicolons delimit options for values that are Positive; Negative; Zero; Null

 

[nickaccess]

Easiest way to show text instead of a value is with the Format property of the control.

;;;"Invalid"

You can also set the foreground colour.

;;;"Invalid"[Red]

The semicolons delimit options for values that are Positive; Negative; Zero; Null

Sorry I think I am thick as two short planks. No matter what I am doing it will not work.

The expression is looking for a date, if the date is blank I want it to say invalid. At the moment it shows;

IsNull([DATEAPVAL])=TRUE

This just shows it as blue, that is the colour I have chosen in the settings to show. All I want it for it to show, if the date is not there, show the word INVALID and colour it blue.

I am not that brainy when it comes to Access as I have taught myself. riggers has been brilliant, but I think I am the one not understanding you very talented guys.

 

[Minty]

You need to apply Galaxioms code in the format property of the control in the form;

Do that and your conditional formatting to get what you want.

 

[nickaccess]

You need to apply Galaxioms code in the format property of the control in the form;

Do that and your conditional formatting to get what you want.

THANK YOU, this has work, I have now learned something new today. Thanks to EVERYONE and thanks for your patience with this slow learner. You can teach an old dog new tricks.

 

[isladogs]

Easiest way to show text instead of a value is with the Format property of the control.

;;;"Invalid"

You can also set the foreground colour.

;;;"Invalid"[Red]

The semicolons delimit options for values that are Positive; Negative; Zero; Null

Thanks for that Greg. Something new learned for me as well

 

[nickaccess]

ridders, thank you as well from me. I am learning all the time. "If you can learn one new thing every day, then your day has not been wasted".

 

[isladogs]

You're welcome.

None of us here ever stop learning.
The site has many experienced & expert users of Access (etc) but absolutely nobody will ever know all there is to know about Access (if you see what I mean)