Hello,
I have a combo box that populates another text box. Row Source: SELECT [Request Templates].ID, [Request Templates].Template, [Request Templates].Field1 FROM [Request Templates] ORDER BY [Request Templates].Template ... FIELD1 in the query is a memo type of field to allow for a longer character count. All the text fits in the table. The item selected from the combo box populates another text box which has a control source of: =[Combo123].[Column](2) This all works except, the text is truncated in the text box if i choose an item that has a large character count.
Example:
I choose 'Server - Racking / Cabling request' from drop down
Text to display in text box from table:
'1.) Locate server and confirm it matches the model information included in this request. 2.) Install rails in space as specified in CI Info section. 3.) Install server. 4.) Connect and label cables. 5.) Connect LAN and console cables as specified in CI Info section. 6.) Power on server. 7.) Notify RSO team that these steps have been completed so that they may proceed with the next step. DO NOT close workorder until you receive authorization from RSO team.'
The actual text that is displayed in text box after combo box selection:
'1.) Locate server and confirm it matches the model information included in this request. 2.) Install rails in space as specified in CI Info section. 3.) Install server. 4.) Connect and label cables. 5.) Connect LAN and console cables as specified in CI In'