Results 1 to 3 of 3
  1. #1
    imintrouble is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    Missouri, where frownin's a sport
    Posts
    127

    no blank fields

    Hello! In my form, the user has to enter the information specified in three different fields, User Name, User Type (which is a select box with three choices to choose from), and their E-mail. I want to put some code into the unload function which will bring up a message box informing them that they must make sure all fields are filled in, and maybe even tell them which ones still need the information. i beileve this will be done like,

    while username = null (or whatever access does)
    msgbox = "please enter your user name before closing."

    this is the basic thing i want this to do.

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Might consider using the validation properties on each field.

  3. #3
    imintrouble is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    Missouri, where frownin's a sport
    Posts
    127
    and what is that lol ?

    **EDIT**

    Never mind, figured it out. Thanks for the tip!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Setting Blank Fields to "N/A"
    By AKQTS in forum Reports
    Replies: 6
    Last Post: 07-15-2011, 04:40 AM
  2. Using if to find blank fields?
    By newtoAccess in forum Queries
    Replies: 4
    Last Post: 03-20-2011, 10:48 AM
  3. searching for blank fields with a query
    By ironman in forum Queries
    Replies: 0
    Last Post: 03-04-2011, 03:48 PM
  4. Replies: 2
    Last Post: 02-03-2011, 12:41 PM
  5. Look for blank date fields
    By NOTLguy in forum Programming
    Replies: 3
    Last Post: 10-17-2010, 07:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums