Multiple statements on one line in Access VBA

Hi

I would like to convert the following statements to one line (as in Visual Basic.net).  Can this be done in Microsoft Access VBA?


If IsNull(Me.[Quantity]) Then
    Me.[Quantity].SetFocus
    Exit Sub
End If
peispudAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
If IsNull(Me.[Quantity]) Then Me.[Quantity].SetFocus :  Exit Sub

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Note the Colon ...
0
 
peispudAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.