To read the article online, visit http://www.4GuysFromRolla.com/webtech/tips/t102599-1.shtml

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: http://www.4GuysFromRolla.com/webtech/tips/t102599-1.shtml


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