Tuesday, November 23, 2010

Microsoft Access - Add multi-collumn item to ListBox with VBA

Sounds simple enough; but no simple solution found; at least not easily.

Set Columns property of ListBox to 2 columns.

The answer is to use the semicolon as a delimiter. I guess if you have a semicolon in the actual content you would need to escape it.

See http://www.xtremevbtalk.com/showthread.php?s=84c58c3e5e4e7b8cfc7ae3b0fcac6a91&t=143946

Reformation Ideas

  • understanding and comprehension of U.S. constitution demonstrated
  • secret clearance obainment required
  • strict accountability for oaths and promises made
  • no campaigning while serving a term elected to fulfill
  • term limits for all elected officials