>Anyway with a Format or some other way to not allow a minus number to be entered into a textbox? I would like the minus sign not to even be entered into the text box. All the other data is numeric like 999999.00.
>
>Thanks in advance...
>
>Mel

Hi Mel.

This thread is a bit old now.

I know there was a cheap way, but it needs some time. Today I run into it so here it is.

It will not prevent the user frome entering 0 - but it will prevent from using it

The stuff you need is the RangeLow method of the textbox

Just enter RETURN 0 in it - and any value lower 0 will stop the user from leaving the textbox. You can add up a messageboy infront of the return to put a message about the problem.

HTH
Lutz