Text Box Size (1 Viewer)

[wysiwyg]

I am trying to populate a textbox on a form with information from a query when I click on a command button. Other text boxes have been populated via SQL in the Row Source of a combo box.

However, the information for these text boxes are all 'text format' and the problem comes when I am trying to input a 'memo field'.

The combo box limits the data to 255 characters which is too small - I need at least 1000.

How else may I solve this problem? Suggestions would be welcome.

 

[Dennisk]

i've never had problems inputing more than 255 chrs in a memo fields. However you do mention a combo box. are you displaying the contents of a memo field in a combo box?

 

[wysiwyg]

Yes - the detail comes via sql in the row source combo box. The detail shown is dependent on the command button selected.

Example of Function being applied:

Public Function FuncGetDescription(varVitMinVal As String)
Dim strDescription As String

strDescription = "SELECT Qry VitandMin.Description" &_
"FROM QryVitandMin "&_
"WHERE (((QryVitandMin.Name ofVitorMin)= "'& varVitMinVal & "'));"

MsgBox strDescription

FuncGetDescription=strDescription

End Function