[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Multiple statements on one line in Access VBA

Posted on 2012-03-16
3
Medium Priority
?
583 Views
Last Modified: 2012-03-16
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
0
Comment
Question by:peispud
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 37731973
If IsNull(Me.[Quantity]) Then Me.[Quantity].SetFocus :  Exit Sub

mx
0
 
LVL 75
ID: 37731974
Note the Colon ...
0
 

Author Closing Comment

by:peispud
ID: 37731982
Thanks
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question