General information
Category:
Forms & Form designer
>I have a combo box based on Select Statement. The width of the field is 100 characters. It seems like the column width is defaulting to this feild width even though I have used AllT() in my SQL statement and set the column width to 50. How can I force the combo box widht to be smaller?
If you want the selected field width to be 50, then use LEFT(myField,50) in your SQL-Select instead of alltrim. The size of the field in the first selected row will determine the width of all the rest.
If you want the drop down display of the combobox to fit roughly 50 chars then you'll need to set the width of the combobox. The width depends on the screen font. Check out the _screen.textwidth and sysmetric help topics.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only