Re: Imput Mask creating a problem in field for input on form
- From: "Rich1234" <Rich1234@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 27 Sep 2005 05:25:02 -0700
Hi Al
Thanks for your replies. Good lateral thinking! The click now always goes
to the far left of the field. Nice one!
I tried the Validation rule... it works. I also tried the code you sent but
get the error "Compile Error: Block If without End If" . ..this opens up the
debugger so there's something there VBA doesn't like.
I've just changed the onclick event to your new suggestion. Before it
was:[VRM].SelLength=7
Thanks Al
Rich
"Al Camp" wrote:
> Also... Copy and Paste the code you wrote on the OnClick event into your
> reply.
> hth
> Al Camp
> Candia Computer Consulting - Candia NH
> http://home.comcast.net/~cccsolutions
>
> "Al Camp" <anon@xxxxxxxx> wrote in message
> news:uG2xBsqwFHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
> > Rich,
> > Use the OnClick event for your date field with this code (ex. ShortDate
> > field)
> > [YourField].SelLength = 8
> > Adjust the 8 to suit your format. That should select the whole date
> > format if you mouse click into the field, and tabbing will work as always.
> > --
> > hth
> > Al Camp
> > Candia Computer Consulting - Candia NH
> > http://home.comcast.net/~cccsolutions
> >
> > "Rich1234" <Rich1234@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:591B2F02-6DA5-49F8-AA2C-1DD4E11CEAF9@xxxxxxxxxxxxxxxx
> >> Hi
> >>
> >> I'm using an input mask on a field. The mask is
> >>>Aaaaaaa (so the last 6 characters are optional.)
> >> The mask is set up so that the underscore character appears for every
> >> character in the mask, denoting the field length (this includes the
> >> optional
> >> characters.)
> >> The problem is this: if a user clicks on the field on a form (rather
> >> than
> >> tabbing to it,) if they don't click on the very far left of the field,
> >> the
> >> cursor "lands" somewhere between the start and end of the field which is
> >> very
> >> fiddly for data input. The user will either have to use the left arrow
> >> key
> >> to go to the start of the field... or, even worse, they might not even
> >> realise that they're not at the start of the field and type in a short
> >> entry
> >> (maybe 3 characters) midway in the field!
> >>
> >> How can I prevent this? Hopefully users will tab to the field but I need
> >> to
> >> sort this so they can't click somewhere in the middle.
> >>
> >> Also I've just found that when you use "a" in a mask, it permits a space
> >> to
> >> be entered! Is there any way that you can specify a mask for an optional
> >> character (either letter or digit) so that it cannot be a space? I need
> >> to
> >> ensure a user doesn't enter any gaps between characters in the field.
> >>
> >> Can you help?
> >> TIA if you can
> >>
> >> Rich
> >
> >
>
>
>
.
- Prev by Date: Re: Return vs. Tab
- Next by Date: Re: Math problem
- Previous by thread: Re: Imput Mask creating a problem in field for input on form
- Next by thread: Re: Imput Mask creating a problem in field for input on form
- Index(es):
Relevant Pages
|
