Text Box in Forms

[Gringarlow]

Why is it called a text box if I can't format it to accept text? I need to
have a control/input on the form that will accept 1102A as an input to a
query.Can you help me here?
ThankYou

 

[Larry Linson]

Why is it called a text box if I can't format it to
accept text? I need to have a control/input on the
form that will accept 1102A as an input to a
query.Can you help me here?

There's nothing inherent about a Text Box that would prevent entering
"1102A". Perhaps if you gave some detail, someone would be able to make a
useful suggestion, or at least, ask additional questions. Is your Text Box
bound or unbound (a good start is to tell us what is in its Control Source
property), does it have a validation rule specified. Exactly what happens
when you enter the value 1102A? What error message is returned, if any?
How, exactly is it "input to a query".

Larry Linson
Microsoft Office Access MVP

 

[Jeff Boyce]

In addition to Larry's very cogent observations, is there a chance that your
underlying query is not updateable?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Gringarlow]

When I enter 1102A into the text Box on the form it returns - "The value you
entered isn't valid for this field. For example, you may have entered text in
a numeric field or a number that is larger than the FieldSize setting permits"

It is unbound.
On the properties sheet the Format field has no choice for TEXT, only
numeric, Long Date, short date, General Number,... or logic choices Yes/No,
True/False...

I can go to the query and enter 1102A directly into the criteria field from
the design view and get the results I'm looking for.
Hope this helps with your help

 

[John W. Vinson]

When I enter 1102A into the text Box on the form it returns - "The value you
entered isn't valid for this field. For example, you may have entered text in
a numeric field or a number that is larger than the FieldSize setting permits"

It is unbound.

Recheck the form.

That message means that the textbox IS bound, probably to a Number or Lookup
field.

Open the form in design view; view its Properties; select the textbox. Is
there anything in the Control Source property of the textbox?

 

[Gringarlow]

There is nothing in the control source of the textbox
It is surely Unbound.
I tried to copy and paste a screen shot, but I guess its not possible here.

 

[Linq Adams via AccessMonster.com]

Actually, Access will pop that error on an Unbound field, but only if its
Format Property is set to anything.To have it allow alpha/numeric text you
should simply have the Format Property set to nothing.

If it is set to nothing and the control has no Control Source, you'd have to
think about the control being corrupt, and try deleting the recreating it.