how is the best way to only accept currency data to a text box.
-
-
Re: Text box filter
Use the Validate event. Check first to see if it is a number. if it is
a number, check for a decimal point. if the decimal is not there then
append ".00" to the end. If it is not a number then set the text to an
empty string, Cancel = true and set the focus back on the text box.
Use the IsNumeric and InStr functions.
David
"Oin Zea" <OinZea@hotmail .com> wrote in message news:<AUYJc.16$ ab.14@fe39.usen etserver.com>.. .[color=blue]
> how is the best way to only accept currency data to a text box.[/color]
Comment