If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change a text box to a combo box
Hi there
I have created several forms in my database. I realized that I should have made them combo boxes instead of text boxes. Is there any easy way for me to change them into the format I need? Thank you in advance for your help. |
#2
|
|||
|
|||
Change a text box to a combo box
Right-click on the text box and select changeTo from the menu.
-- Reggie "forest8" wrote in message Hi there I have created several forms in my database. I realized that I should have made them combo boxes instead of text boxes. Is there any easy way for me to change them into the format I need? Thank you in advance for your help. |
#3
|
|||
|
|||
Change a text box to a combo box
Do as Reggie said, but you’ll then have to enter the control’s RowSource
property at least; and possibly also have to amend its BoundColum, ColumnCount and ColumnWidths properties if the combo box is to show a value from a column or columns in another table referenced by a ‘surrogate’ foreign key in the form’s underlying table. A combo box bound to an EmployeeID foreign key column for instance might be set up as follows: RowSource: SELECT EmployeeID, FirstName & " " & LastName FROM Employees ORDER BY LastName, FirstName; BoundColum: 1 ColumnCount: 2 ColumnWidths: 0cm;8cm If your units of measurement are imperial rather than metric Access will automatically convert the last one. The important thing is that the first dimension is zero to hide the first column and that the second is at least as wide as the combo box. Ken Sheridan Stafford, England forest8 wrote: Hi there I have created several forms in my database. I realized that I should have made them combo boxes instead of text boxes. Is there any easy way for me to change them into the format I need? Thank you in advance for your help. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|