text box starts with zero on a form I created

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ineed to be able to have an 11 character space. 1st space may be a letter or
number INCLUDING THE NUMBER ZERO!. The next 10 characters will all be
numbers. I have tried !A&&&&&&&&&&;;_ under the properties as well as all
the optional code variations. It cannot be a numerical box because of the
possibility of the first characters being a letter. I seriously need help.
Please. and of course, thanks.
 
An 11 character text field would work generally. The appropriate mask (as
defined in the relevant form) would limit input to alpha or numeric. If
you've done all this, you're mask may be wrong, keep trying more variations.
 
Unfortunately, that's why I posted. I've tried all the masks. I don't know
what's wrong. I gave the mask I've used. I've also tried !&&&&&&&&&&&;;_
and !CCCCCCCCCCC;;_ and !aaaaaaaaaaaa;;_ and !AAAAAAAAAAA;;_ and
nothing works. I don't understand where else I should look. Is there
another field other than the mask in properties, that may be affecting how
this field is working regarding the ZERO
 
I don't see why 0 should be causing a problem. Are you saying that 0 causes
a problem but other numbers don't? That sounds fishy, and could be a
Windows error. Try restarting your computer.
 
Better to use a validation rule, e.g.

Like "[0-9A-Z]##########" Or Is Null

perhaps supplemented with an input mask of
 
John, I think that this is closer. I tried various validations, such as
moving the " around and even creating a conditional format but that didn't
work (1st was between A and Z and second between 0 and 9). At least it was
giving me a different answer. I also tried different codes such as A, &, C,
as well as the #. The message I get is "The value you entered doesn't meet
the validation rule defined for the field for the control. I am trying to
enter the number 00249137202 or something similar. (and have the zero show
up.) I would then try (If I got beyond that,) to substitue the same number
starting with a B instead of the first 0. I have even trashed the whole box
and started a new box without results)
I've done so much with this think on my first try. I don't want this little
thing to defeat me, LOL


John Nurick said:
Better to use a validation rule, e.g.

Like "[0-9A-Z]##########" Or Is Null

perhaps supplemented with an input mask of

>A##########


Ineed to be able to have an 11 character space. 1st space may be a letter or
number INCLUDING THE NUMBER ZERO!. The next 10 characters will all be
numbers. I have tried !A&&&&&&&&&&;;_ under the properties as well as all
the optional code variations. It cannot be a numerical box because of the
possibility of the first characters being a letter. I seriously need help.
Please. and of course, thanks.
Click to expand...
Click to expand...
 
If you apply the validation rule I gave you to a text field of size 11
or larger, it will accept a letter (A-Z or a-z) or number (0-9) followed
by a further 10 characters, and reject anything else except for leaving
the field empty. I.e. it accepts your example below 00249137202 as well
as things like 01234567890 and Z0123456789.

The input mask specifies a letter or number followed by 10 numbers, with
the initial > converting the letter to uppercase if the user types
lowercase (e.g. a to A). It's only real usefulness is to do the
automatic upper-casing.

You can also apply the validation rule (and if you choose, the input
mask) to a textbox bound to a text field of size 11 or larger.

So I can't quite see how you're getting into trouble.

John, I think that this is closer. I tried various validations, such as
moving the " around and even creating a conditional format but that didn't
work (1st was between A and Z and second between 0 and 9). At least it was
giving me a different answer. I also tried different codes such as A, &, C,
as well as the #. The message I get is "The value you entered doesn't meet
the validation rule defined for the field for the control. I am trying to
enter the number 00249137202 or something similar. (and have the zero show
up.) I would then try (If I got beyond that,) to substitue the same number
starting with a B instead of the first 0. I have even trashed the whole box
and started a new box without results)
I've done so much with this think on my first try. I don't want this little
thing to defeat me, LOL


John Nurick said:
Better to use a validation rule, e.g.

Like "[0-9A-Z]##########" Or Is Null

perhaps supplemented with an input mask of

>A##########


Ineed to be able to have an 11 character space. 1st space may be a letter or
number INCLUDING THE NUMBER ZERO!. The next 10 characters will all be
numbers. I have tried !A&&&&&&&&&&;;_ under the properties as well as all
the optional code variations. It cannot be a numerical box because of the
possibility of the first characters being a letter. I seriously need help.
Please. and of course, thanks.
Click to expand...
Click to expand...
Click to expand...
 
I think that I've had the answer with your last validation rule and there is
something wrong with this version(at work). I've applied it as stated and I
agree, it should work. It however, doesn't. the logic is there, the error
message still appears. This software has been tweeked corporately so much,
who knows. I will run it on my own Access 2003 and see how it is, and hope
it is backwards compatible. Thanks for all the assistance.

John Nurick said:
If you apply the validation rule I gave you to a text field of size 11
or larger, it will accept a letter (A-Z or a-z) or number (0-9) followed
by a further 10 characters, and reject anything else except for leaving
the field empty. I.e. it accepts your example below 00249137202 as well
as things like 01234567890 and Z0123456789.

The input mask specifies a letter or number followed by 10 numbers, with
the initial > converting the letter to uppercase if the user types
lowercase (e.g. a to A). It's only real usefulness is to do the
automatic upper-casing.

You can also apply the validation rule (and if you choose, the input
mask) to a textbox bound to a text field of size 11 or larger.

So I can't quite see how you're getting into trouble.

John, I think that this is closer. I tried various validations, such as
moving the " around and even creating a conditional format but that didn't
work (1st was between A and Z and second between 0 and 9). At least it was
giving me a different answer. I also tried different codes such as A, &, C,
as well as the #. The message I get is "The value you entered doesn't meet
the validation rule defined for the field for the control. I am trying to
enter the number 00249137202 or something similar. (and have the zero show
up.) I would then try (If I got beyond that,) to substitue the same number
starting with a B instead of the first 0. I have even trashed the whole box
and started a new box without results)
I've done so much with this think on my first try. I don't want this little
thing to defeat me, LOL


John Nurick said:
Better to use a validation rule, e.g.

Like "[0-9A-Z]##########" Or Is Null

perhaps supplemented with an input mask of

>A##########


Ineed to be able to have an 11 character space. 1st space may be a letter or
number INCLUDING THE NUMBER ZERO!. The next 10 characters will all be
numbers. I have tried !A&&&&&&&&&&;;_ under the properties as well as all
the optional code variations. It cannot be a numerical box because of the
possibility of the first characters being a letter. I seriously need help.
Please. and of course, thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top