Comment on Null Field

[NDD]

Well that worked just fine Ms. Gina. I truly appreciate it. I shall research subreport. Enjoy your coffee and have a great day.

Could you edit your quote of my query SQL, I'd rather not have all that information out and about. Thank you.

 

[GinaWhipp]

Glad to help!

 

[NDD]

Please see my addition to the above.

If you would just take out everything after your red insertion, that would be great and people can still learn from your wisdom.

 

[NDD]

Many thanks Gina, you're a peach.

 

[BlueIshDan]

That code is for a report actually. I put it in the Click event of a text box.

 

[GinaWhipp]

BlueIshDan,

That would no have produced the desired results, it really needs to be in the RecordSource of the Report.

 

[BlueIshDan]

It really doesn't. I wouldn't say it works if I didn't test it. I tested it, thinking that it would't be able to check the distinct text box's (being clicked) value, but it did.

 

[GinaWhipp]

BlueIshDan,

Interesting because I couldn't get it to work on a continuous report. I'll try that again!

 

[BlueIshDan]

Might have to do with different versions of access?
View attachment test.accdb

 

[GinaWhipp]

BlueIshDan

That is not the same code you posted. It's the code you posted I was referring to.

 

[BlueIshDan]

Private Sub txtSSEEndDate_Click()
If IsNull(txtSSEEndDate.Value) Then: MsgBox "msg"
End Sub

Also works for me.
I feel like this needs to stop.

 

[GinaWhipp]

Yeah, probably.. we are both doing something different and we'll probably not figure it out in this thread!