Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

check textbox values using MS Access 2010

Posted on 2011-05-08
2
Medium Priority
?
293 Views
Last Modified: 2012-05-11
I'm using MS Access 2010 and it doesn't seem to let me check textbox values the way I was able to in earlier versions.   For example, let's say on a form I have textbox that checks for vlaid data entry by a user.  I used to do something like:

If MyTextBox > 12/31/2010 then
   msgbox "Invalid date"
   MyTextBox.Setfocus
else
etc
etc

I don't see Setfocus available in the list. Also, I don't see things like ".Value"  
How am I supposed to error check textboxes now?
0
Comment
Question by:dbfromnewjersey
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 35715394
Textboxes in Access 2010 still have a .Value property, and the SetFocus method is still available.

I would susupect you're either NOT dealing with a Textbox, or you're working with a Web database. The web-enabled database type does not  have many of the familiar properties you're accustomed to seeing in Access.
0
 

Author Comment

by:dbfromnewjersey
ID: 35715420
Stupid mistake on my part. When I panic, that always happens. What it was is that I had a textbox misnamed.  Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

564 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