Input data check

[bob]

Hi



I want to check 10 fields to confirm they have data entered into them.
Before I print a document.



Field1 Not is null



Field2 Not Isnull



And so on. If any of the fields are blank I want a msgbox to appear
listing the field names which have no data. I do not want to set the field
to, data required, because there may be a reason why we have been unable to
enter the required data.



How do I set this up?



Thanks



Bob

 

[Gina Whipp]

Bob,

Something like... Use check boxes, combo boxes, text boxes, etc...

If IsNull(Me!CheckBox1) Then
MsgBox "You must enter data in CheckBox1"
Me!CheckBox.SetFocus

ElseIf IsNull(Me!CheckBox2) Then
MsgBox "You must enter data in CheckBox2"
Me!CheckBox.SetFocus

ElseIf IsNull(Me!CheckBox3) Then
MsgBox "You must enter data in CheckBox3"
Me.CheckBox.SetFocus

'***Keep going till all your check boxes are accounted for

Else
'Do Something Here
End If

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi



I want to check 10 fields to confirm they have data entered into them.
Before I print a document.



Field1 Not is null



Field2 Not Isnull



And so on. If any of the fields are blank I want a msgbox to appear
listing the field names which have no data. I do not want to set the field
to, data required, because there may be a reason why we have been unable to
enter the required data.



How do I set this up?



Thanks



Bob

 

[bob]

Gina

That works fine.

Thanks for your help.

Regards Bob

 

[Gina Whipp]

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina

That works fine.

Thanks for your help.

Regards Bob