|
|
Checking a forms fields for null
Hi All,
I can think of a few ways to accomplish this, but would like to know of a
better way.
just like when you fill out forms on the web if the field is mandatory it
pops up a msg say somthing like "This field isn't optional" if it is left
blank. What is the best way to do this in access on a form?
I'm using now:
if ISNull(myFeild1) then
msgbox"Please fill in myFeild1"
end if
If ISNull(myFeild2) then
msgbox"Please fill in myFeild2"
end if
if ISNull(myFeild3) then
msgbox"Please fill in myFeild3"
end if
|
|
0
|
|
|
|
Reply
|
 Utf
|
5/27/2010 8:18:45 PM |
|
I use something similar to what you are suggesting however my validation if
more than one field is null it will list all the fields that are null. I
chopped a small bit of it below.
Dim strMsg As String
If IsNull(Me.Audit_nme) Then
Cancel = True
strMsg = strMsg & "Audit Name required." & vbCrLf
End If
If IsNull(Me.Combo61) Then
Cancel = True
strMsg = strMsg & "Auditor required." & vbCrLf
End If
If IsNull(Me.DateAudit) Then
Cancel = True
strMsg = strMsg & "Date Initiated." & vbCrLf
End If
If Cancel Then
strMsg = strMsg & vbCrLf & "Correct the entry, or press <Esc> to
undo."
MsgBox strMsg, vbExclamation, "Invalid entry"
End If
"Mark" wrote:
> Hi All,
>
> I can think of a few ways to accomplish this, but would like to know of a
> better way.
>
> just like when you fill out forms on the web if the field is mandatory it
> pops up a msg say somthing like "This field isn't optional" if it is left
> blank. What is the best way to do this in access on a form?
>
> I'm using now:
>
> if ISNull(myFeild1) then
> msgbox"Please fill in myFeild1"
> end if
> If ISNull(myFeild2) then
> msgbox"Please fill in myFeild2"
> end if
> if ISNull(myFeild3) then
> msgbox"Please fill in myFeild3"
> end if
|
|
|
0
|
|
|
|
Reply
|
Utf
|
5/27/2010 9:09:13 PM
|
|
|
1 Replies
557 Views
(page loaded in 0.048 seconds)
Similiar Articles: Checking a forms fields for null - microsoft.public.access ...Hi All, I can think of a few ways to accomplish this, but would like to know of a better way. just like when you fill out forms on the web if the field is ... checking to see if a date feild is null - microsoft.public.access ...Hi I am trying to check when a record that loads in to a form to see if a date field is null but it errors out with a runtime error 424 The code I us... How to check Required Form Fields before Saving or Printing ...Checking a forms fields for null - microsoft.public.access ... How to check Required Form Fields before Saving or Printing ... How to check Required Form Fields before ... VB code for checking if a field is not null (for locking a row) is ...hi, I need to automatically lock a field after it's been written into and has lost focus. Right now I'm using a checkbox, but I want to lock automat... Check to see if a specific field exist on form - microsoft.public ...Hi SF, I think you are asking if the field Owner has a value (meaning that it's not null or empty). If I have not understood please let me know. How to check continuous form fields - microsoft.public.access ...... Field MUST be completed", vbCritical + vboko, "You left fields empty ... How to check continuous form fields - microsoft.public.access ... Lock Current record on a ... Exclude a field from WHERE clause, if null - microsoft.public ...I want to exclude a form field from the SQL ... frmMyForm]![txtLastName] Is Null)) If you're building the query on the fly in VBA code, you can simply check which form ... set text box to blank(Null) - microsoft.public.access.forms ...... If Null... - microsoft.public.access ... empty text box input on form to null ... to hide a text field label when the field is null? Access2003 ... Check if field is empty ... Not Null not working - microsoft.public.access.forms... validation rule for each not to be null. I also have the two fields in the table being required. On my Login form I ... to save it. > >Doug's suggestion, checking in the ... Checking for duplicate data - microsoft.public.access.forms ...Duplicate data from field into another field in same form ... Check Box To Copy ... Checking for duplicate data - microsoft.public.access.forms ... MsgBox "Address is Null. Validate empty fields and e-mail address input with JavaScript.Script written by . Description: Checking that form fields have input is extremely important - having this performed before the form is submitted, client side, before ... Checking a forms fields for null - microsoft.public.access ...Hi All, I can think of a few ways to accomplish this, but would like to know of a better way. just like when you fill out forms on the web if the field is ... Download Validate Empty form fields JavaScript - Validate Empty ...Validate Empty form fields JavaScript Validate Empty form fields JavaScript code contains functions to check null input in form fields and also to check if an email ... CodeToad - Javascript Form Validate Empty Field function.Javascript Form Validation function ... This function can be used to check whether the user has entered anything in a given field. Check empty fields | PHP form validation - PHP Script Resource ...Simple form field validation, demonstration. This is an example about how to use this function. Check also the code on the snippet page for further explanation. 7/21/2012 3:38:36 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
31 followers. 