468,765 Members | 946 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

Creating custom Input Masks...

Morning All,

I'm trying to ensure that when the user enters a number on a form, the
database automatically leaves a space after the 3rd number. I've tried
to do this using input masks, but when I tab to the text box, the ___
_____ shows up and I can't enter anything at all.

Cheers

Reg

Nov 13 '05 #1
6 5734
Regnab wrote:
Morning All,

I'm trying to ensure that when the user enters a number on a form, the
database automatically leaves a space after the 3rd number. I've tried
to do this using input masks, but when I tab to the text box, the ___
_____ shows up and I can't enter anything at all.

Cheers

Reg


Is your control source (field from the table) a number field or text
field? If number, change it.

You might want to write a function to insert the space into a field that
contains numeric. Since it appears you don't have any control over
where the 3 numbers appear; 123 56 or A123 56 or AB123 56 then an input
mask would be a bit worthless don't you think?
Nov 13 '05 #2
Cheers for the response Salad, but I think you may have misunderstood
what I meant. The space is at the 3rd number - the 3rd character. Eg
982 000039485483. And at the moment, I believe it is a text field. It's
a number which comes from an RFID tag on an animal.... all cattle in
Australia now have a RFID device which when scanned produces this 16
digit (15 digits and a space) number. From time to time they get
entered by hand = voila the reason I'm trying to use the input mask.

Nov 13 '05 #3
Regnab wrote:
Cheers for the response Salad, but I think you may have misunderstood
what I meant. The space is at the 3rd number - the 3rd character. Eg
982 000039485483. And at the moment, I believe it is a text field. It's
a number which comes from an RFID tag on an animal.... all cattle in
Australia now have a RFID device which when scanned produces this 16
digit (15 digits and a space) number. From time to time they get
entered by hand = voila the reason I'm trying to use the input mask.

I created a text field on a form. For the input mask I have
###\ ############
and it appears to work OK.

Open up the form in design mode and open up the property sheet for the
text field. Then click on the data tab. See waht you have as the input
mask. Next, under the input mask you'll see Enabled and Locked. Verify
Enabled is True and Locked is False. It's quite possible Locked is set
to True thus allowing you to have focus to the field but not the ability
to enter data.
Nov 13 '05 #4
Perfect - thanks for your help Salad....

Nov 13 '05 #5
Try this:

000\ 000000000000;0;" "

Nov 13 '05 #6
Cheers Setup....but don't they both do the same thing or am I missing
something??

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Mark Lees | last post: by
4 posts views Thread by David W. Fenton | last post: by
7 posts views Thread by F. Michael Miller | last post: by
2 posts views Thread by pshvarts | last post: by
2 posts views Thread by bobrics | last post: by
4 posts views Thread by Dave | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.