Hi Guys:

I am using InputBox to permit input to a routine and would like to limit the
alpha-numeric input to use uppercase characters only.

This is the line I am using:

NewClient = InputBox("SNAM of New Client (AAA123)")

Is there a way to limit the alpha characters to uppercase only within the
inputBox line?

Thanks,
Craig

Don't bother the user:

NewClient = ucase(InputBox("SNAM of New Client (AAA123)"))

But there's no way to do this kind of masking using an inputbox.

Craig Brandt wrote:
>
> Hi Guys:
>
> I am using InputBox to permit input to a routine and would like to limit the
> alpha-numeric input to use uppercase characters only.
>
> This is the line I am using:
>
> NewClient = InputBox("SNAM of New Client (AAA123)")
>
> Is there a way to limit the alpha characters to uppercase only within the
> inputBox line?
>
> Thanks,
> Craig

--

Dave Peterson

This is exactly what I was looking for.


Thanks Dave.


"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:48164D10.8CB6F1E9@verizonXSPAM.net...
> Don't bother the user:
>
> NewClient = ucase(InputBox("SNAM of New Client (AAA123)"))
>
> But there's no way to do this kind of masking using an inputbox.
>
> Craig Brandt wrote:
> >
> > Hi Guys:
> >
> > I am using InputBox to permit input to a routine and would like to limit
the
> > alpha-numeric input to use uppercase characters only.
> >
> > This is the line I am using:
> >
> > NewClient = InputBox("SNAM of New Client (AAA123)")
> >
> > Is there a way to limit the alpha characters to uppercase only within
the
> > inputBox line?
> >
> > Thanks,
> > Craig
>
> --
>
> Dave Peterson