To read the article online, visit

User Tips: Improving the readability when using GetString

From Jason H.:

In the article on GetString, it is shown that you should use GetString to create one giant string for tables, combos, etc from a recordset column. This is not necessary, as you can make your GetString parameters like this:

theCombo = "<option>" & prsRecordset.GetString(,,,"</option>" & vbCrLf & vbTab & "<option>","&nbsp;" )

vbCrLf inserts a linefeed, and vbTab indents. This makes for pretty code, too (thus eliminating your statement that it may be ugly, but it works!)

Article Information
Article Title: User Tip: Improving the readability when using GetString
Article Author: Scott Mitchell
Article URL:

Copyright 2019 QuinStreet Inc. All Rights Reserved.
Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers