A field shows a numeric value and not the text enterred

  • Thread starter Thread starter Dave Boreham
  • Start date Start date
D

Dave Boreham

My table is populated from a form. I enter a place name into a combo box.
When I then look at the table the field for this box shows a numeric value
and not the name
 
Check the datatype of the field in the table and check the control source of
the form.
 
Check the Bound Column of the Combo Box, you are populating the table with
the PK field instead of the Text Field column. Try changing the bound column
by adding one to the current value and see what that does for you? (Eg
Current Bound Column = 1 try Bound Column =2)

Hope this answers your question???

Regards

Mike B
 
On Thu, 11 Dec 2008 04:38:03 -0800, Dave Boreham <Dave
My table is populated from a form. I enter a place name into a combo box.
When I then look at the table the field for this box shows a numeric value
and not the name
Click to expand...

That's almost surely *exactly what should be happening*.

Table datasheets are not designed for user interaction, but for data storage.
If each place name may occur in many records in your table, then you should in
fact store the text of the place name - once only - in a placenames table, the
row source of your combo box; and store only the numeric foreign key to the
placename table in your main table. If you want to see the place name in
conjunction with other data in the table use a Combo Box on a form (bound to
the numeric ID but showing the text); or use a Query joining your table to the
placename table as the recordsource for a Report.
 
Back
Top