Create a Message Box in Calculated Field

L

Luman

Hi,
I would appreciate any help in this area.
I have designed a form which creates mixes for specific colors.
Each color type has a percentage recorded to create the mix.
I have added a calculated field at the bottom of the form to total the
percentages.
It all adds well and works perfect.
What I am trying to do is, have a message box WARNING! if the total
percentages do not equal 100%
I have tried the Validation Rule and Validation Text and it does not seem to
work.
Any suggestions?
Thanks for your time!
Luman
 
K

Kernow Girl

Hi Luman - put an Unbound Text box on your form and (assuming your calculated
field is call Total Percentage ) enter the following =iif([Total
Percentage]=100,"","WARNING!")
Depending on how you entered you percentage you may need to say = 100%

HTH - Dika
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Filtering and summing a calculated field on a subform 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Calculated field in a table 6
Setting language of a selected text in Office apps. 0
Create a chart from a table in word thats dynamic 0
Creating a Search using a combo box and then creating a report. 4
How to create Access 2010 Calculated field using VBA ? 1

Top