Text box instead of combobox

  • Thread starter Thread starter jeff klein
  • Start date Start date
J

jeff klein

My frm_Orders record source is tbl_Orders.
On the frm_Orders I have a combobox that shows Item price - the combobox
control source is ItemID and the record source is SELECT DISTINCTROW
tbl_Items.ItemID, Item.Rate FROM tbl_Items. This shows the price of the item
in the orders form.

OK...what would be the way to show the same information in a text box
instead of the combobox?
 
jeff said:
My frm_Orders record source is tbl_Orders.
On the frm_Orders I have a combobox that shows Item price - the
combobox control source is ItemID and the record source is SELECT
DISTINCTROW tbl_Items.ItemID, Item.Rate FROM tbl_Items. This shows
the price of the item in the orders form.

OK...what would be the way to show the same information in a text box
instead of the combobox?
Click to expand...

Make the selection.
Loop through the records and create a string that would properly display in
the text box for that particular width (with scroll bars) and type size.
Plug it into the textbox.
Not difficult but time consuming.
 
Back
Top