Use a comma in a RowSource (1 Viewer)

ggj13557

Registered User.
Local time
Today, 14:03
Joined
May 10, 2004
Messages
11
I am trying to place items in a "Value List" RowSource Type. However, I can't use an item with a comma in the rowsource treats it as a separate item.

Is it possible to use a comma in a list as such:

"CONFIDENTIAL;FOR OFFICIAL USE ONLY;SECRET;SECRET//NOFORN;SECRET//FRD;SECRET//FRD, NOFORN"

Thanks in advance.
 

DJkarl

Registered User.
Local time
Today, 13:03
Joined
Mar 16, 2007
Messages
1,028
I am trying to place items in a "Value List" RowSource Type. However, I can't use an item with a comma in the rowsource treats it as a separate item.

Is it possible to use a comma in a list as such:

"CONFIDENTIAL;FOR OFFICIAL USE ONLY;SECRET;SECRET//NOFORN;SECRET//FRD;SECRET//FRD, NOFORN"

Thanks in advance.

Try putting single quotes around each item

Code:
'CONFIDENTIAL';'FOR OFFICIAL USE ONLY';'SECRET';'SECRET//NOFORN';'SECRET//FRD';'SECRET//FRD,NOFORN'
 

Users who are viewing this thread

Top Bottom