Validate on sum of multipule textboxes

[Deutz]

Hi and thanks in advance.



I'm using Access 2003 and have three textboxes formatted to percent with zero decimal places.

I am wondering if it's possible to validate each textbox as the user enters a figure, ensuring the total percent (all the three textboxes summed) does not exceed 100 percent?

I suppose I could do the validation on saving but as I will have quite a number of these scenarios in database, I thought it would be better to validate at the time the user enters the data, if possible.

Thanks
Michael

[Rixxe]

Hi, I cannot help you write the code, but i found a link or 2 on validation using VB:

http://forums.aspfree.com/visual-bas...ion-21712.html
http://www.ozgrid.com/VBA/validate-numbers.htm

There's actually loads out there, my suggestion would be to take the basic code, and adapt it based on what you need and come back once you have something which just needs tweeking.

Good Luck

[Deutz]

Thanks for your answer Rixxie,

However, the info in your links doesn't really answer my question as I'm trying to validate what's being entered into a textbox based on the sum of: (the value being entered and the values existing in two other textboxes) ... must all add up to <= 100%

[Rixxe]

The idea is similar, for example:

int ThatNumber = 100;

If (textBoxA.Text + textBoxB.Text + TextboxC.Text == ThatNumber)
{
Allow it to perform the task
}
else
{
Error Message, and wipe the text boxes or something
}

Obviously its not even close to the correct syntax, but it should be possible to do something similar just fiddeling around with it.
It easy to say 'If textbox = something, do this' So it shouldnt be that difficult with the syntax from the links posted.
If however you want someone to write it for you, then hopefully they will answer and help you out

Good Luck.

[Deutz]

Thanks Rixxie,

You example was helpful. The problem I had was due to formatting the textboxes as percent so that when I added them together I was not getting the right result. I came up with this validation rule which now works: Is Null Or (>0 And (nz([TextBox1)+nz([Textbox2])*100+nz([TextBox3])*100)<=100).