• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Working with ADO Recordsets,... > Formatting Value List Combo Box Colu...

Formatting Value List Combo Box Columns

To eliminate all long-term read locks from execution of frmComboVBA, you also must convert the lstLineItems list box to use a Recordset-based value list. When you create a value list from a Recordset with currency and percentage formatting, the format attributes are lost. You use the Type property of the Field object to detect fields of the Currency data type. There's no Percentage field data type, so you must explicitly identify field(s) that require percentage formatting.

Follow these steps to make the modifications to the lstLineItems list box:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint