AcSeparatorCharacters Enumeration (Access)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Used with the ComboBox.SeparatorCharacters Property (Access) property to specify the separator displayed between values in combo boxes that are linked to multi-valued fields.

Name

Value

Description

acSeparatorCharactersComma

3

A comma (,) is used as the separator character.

acSeparatorCharactersNewLine

1

Each value appears on its own line.

acSeparatorCharactersSemiColon

2

A semicolon (;) is used as the separator character.

acSeparatorCharactersSystemSeparator

0

The List separator setting in the Regional and Language Options in Windows Control Panel is used as the separator character.

Show: