Validation Rule

[Jason]

I am trying to create a validation rule that will automatically check an
incomplete box that i have created. This will be checked if the user did not
fill out certain fields that they are needing to fill data into. Example
would be like if they didnt enter in a phone number for the person. the
incomplete box will be checked. Can anyone help with the query for this

 

[John W. Vinson]

I am trying to create a validation rule that will automatically check an
incomplete box that i have created. This will be checked if the user did not
fill out certain fields that they are needing to fill data into. Example
would be like if they didnt enter in a phone number for the person. the
incomplete box will be checked. Can anyone help with the query for this

Umm...

Back up a bit.

If the user is entering data with a Form (which they very much should be),
then you can use the Form's BeforeUpdate event to ensure that they CAN'T save
an incomplete record in the first place, with no need to use any sort of
checkbox or validation rule.

In any case, a Validation Rule is not the appropriate tool for this purpose.
It cannot set the value of a table field - only allow or prevent addition of a
record to the table. If you need to check existing data you can create a
control on your to dynamically generate a yes/no (checkbox) value for
incomplete record; just set its COntrol Source to

=(IsNull(ReqField1) OR IsNull(ReqField2) OR IsNull(ReqField3))

for all the required fields. This expression will be True if any of the
required fields is NULL.

 

[Mark Han[MSFT]]

Dear Customer,

Good morning! Welcome to Microsoft MSDN Managed Newsgroup. This is Charles.
I am very glad to work with you on this issue.

My understanding of your issues is that you would like to create a
validation rule to check a box. If I am off-base, please let me know.

in order to address your concern, I would like to explain the following
1 Validation rules prevent bad data being saved in your table. Basically,
they look like criteria in a query. You can create a rule for a field
(lower pane of table design), or for the table (in the Properties box in
table design.) Use the table's rule to compare fields.

2 according to your description, it seems that if the phone number is null
or blank, the row won't be inserted into the table. so, we can create
Validation Rules for fields (You must fill in Field1)

Besides, for more information of validation rule , there are 2 articles to
share with you:

Validation
rules:http://office.microsoft.com/en-us/access/HA102855321033.aspx

How to: Create a Custom Validation
Rule:http://msdn.microsoft.com/en-us/library/ms182556(VS.80).aspx

Please feel free to let me know if you have any other questions or
concerns.

Have a nice day.

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[Mark Han[MSFT]]

Hi Jason,

How are you? I haven't heard from you for a few days.

I am concerned if the explanation I sent was not clear enough. If that's
the case, please tell me directly. I will go through the detail with you
and ensure it is easy for you to follow.

Besides, I understand that you might have a busy schedule and it is
convenient to you to send me a note to tell me the status of the case.

If you have any questions or concerns on the above, please email me.

I look forward to hearing from you.

Thanks.
Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================