Text Box in Forms
in [Form]
|
Prev: Can't Implement Hotfix
Next: TransferText Method
From: Gringarlow on 18 Mar 2010 15:02 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)discussions.microsoft.com> 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 AccessMonster.com on 18 Mar 2010 17:13
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 AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1 |