From: Gringarlow on
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.

"John W. Vinson" wrote:

> On Mon, 15 Mar 2010 13:15:03 -0700, Gringarlow
> <Gringarlow(a)> wrote:
> >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?
> --
> John W. Vinson [MVP]
> .
From: Linq Adams via on
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.

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via

First  |  Prev  | 
Pages: 1 2
Prev: Can't Implement Hotfix
Next: TransferText Method