Use an if statement on a Text Box

**Liam_Sheridan** · 07-16-2014, 05:50 AM

Hi All,

I am making a user entry form where they have to enter some figures. I would like them to only enter a number between 2.4 and 6. How can I do this?

My code at the moment is this:

Please Login or Register  to view this content.

**nathansav** · 07-16-2014, 05:53 AM

put your code on the exit event not the change. and add into the incorrect path me.txtHeight=0, ditch the height number, as its a converted to a string anyway,

Please Login or Register  to view this content.

**Liam_Sheridan** · 07-16-2014, 05:59 AM

Sorry Nathan, you know me, but can you lay it out like code?

This is my code now:

Please Login or Register  to view this content.

**nathansav** · 07-16-2014, 06:04 AM

I have, you just need to replace the calculation with your calculation and the warning message with yours.

**Liam_Sheridan** · 07-16-2014, 06:08 AM

Thanks for that Nathan. However now I am receiving an error - http://gyazo.com/eae2deb94365810d4ebb5144c78efee2

**nathansav** · 07-16-2014, 06:18 AM

Can you post the whole code behind the form

**Liam_Sheridan** · 07-16-2014, 06:27 AM

Yes sure - I have now somewhat fixed the error - instead of converting to string I have converted to Double (DBL).

When an incorrect number is entered, an error is shown (great!) when the number is deleted, it throws and error again (when nothing is entered)

**Liam_Sheridan** · 07-16-2014, 06:29 AM

Please Login or Register  to view this content.

Here is the entire code.

**nathansav** · 07-16-2014, 06:29 AM

Ok, i said to get rid of that. "ditch the height number, as its a converted to a string anyway"

**Liam_Sheridan** · 07-16-2014, 06:31 AM

When that is deleted, it now looks like this:

Please Login or Register  to view this content.

But now it says any number entered is incorrect, and it will not update the total cost text box.

**Liam_Sheridan** · 07-16-2014, 06:41 AM

Thank you Nathan, error now fixed. This is the code I am now using (this may be sloppy, but it works)

Please Login or Register  to view this content.

**nathansav** · 07-16-2014, 07:05 AM

You are doing your if wrong, you only have one outcome, but are still using else,your calc should be before else otherwise it will still calculate after the messagebox has been dispalyed, so do the logic in the IF like i said

Please Login or Register  to view this content.

**Liam_Sheridan** · 07-16-2014, 07:20 AM

I presume you mean

Please Login or Register  to view this content.

instead of 'isnumerc' ?

Use an if statement on a Text Box

LinkBack

Thread Tools

Rate This Thread

Display

Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Re: Use an if statement on a Text Box

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] adding text in front of potentially existing text (in 1 cell) with IF/THEN statement

If Cell contains text, return that text and then perform another if and statement?

[SOLVED] If Or statement to check cell text and delete entire row if text is found

IF statement for text

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions