TextBox dcount function



I'm using the following controlsource in textbox68 to return a count from a
query to a form.


Then OnClose of the form
If Me.Text68 = 0 Then
MsgBox ("text")

If also tried = Is Null, Is Null etc.... but when the value is zero in the
dcount the IfThenElse statement won't recognize it.

any suggestions?




nope, tried = "0" too.

ruralguy via AccessMonster.com said:
How about: If Me.Text68 = "0" Then

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DCount function 4
DCount function 4
IIF function and Dcount function 1
dcount function in a subform 1
Newbie trying DCount Function 1
dcount 1
dcount 4
DCount 2