Product No. Text Box control and 12-001

[ToolJob]

HI I have a Text Box control that is used to enter a product number into the database. When I type 12-001 (format of the number), 12-001 should be plugged into the Access 2010 database. Instead the product number is


being treated as an expression. The result 11 is being plugged into the database incorrectly. How can I disable a text box control to stop this from happening?

Thx

TJ

[June7]

Never encountered this and can't replicate the issue. If you want to provide db for analysis, follow instructions at bottom of my post. Identify the form involved.

[Missinglinq]

Is the Textbox a Bound one? If you select it and go to Properties - Data does the Control Source Property have the Name of a Field in it?

In order for a product 'number' to use the Format of 12-001, the Field has to be defined as a Text Datatype, not a Number Datatype; the dash/hyphen in the 'number' requires this.

It sounds as if your Field is either Unbound or the Field it's Bound to is defined as a Number.

Linq ;0)>

[June7]

I tested entering 12-001 into bound (number and text types) and unbound textbox. Either it errors (bound number type) or accepts the input. Can't replicate issue, no idea what is happening.