Hi,

I have three levels of dependent lists.

I have restricted data entry using validation lists.

User can select Country from the first list.

This then dictates what they can select from State

This then dictates what they can select from Region

The problem is that I can only define the named lists with one word
and its not very pleasing to the eye when the user sees

South_east_precinct

how can i allow the defined lists to have spaces and special
characters?

No spaces in name and no way around it. If you don't like
South_east_precinct how about SouthEastPrecinct?

--
Jim
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| Hi,
|
| I have three levels of dependent lists.
|
| I have restricted data entry using validation lists.
|
| User can select Country from the first list.
|
| This then dictates what they can select from State
|
| This then dictates what they can select from Region
|
| The problem is that I can only define the named lists with one word
| and its not very pleasing to the eye when the user sees
|
| South_east_precinct
|
| how can i allow the defined lists to have spaces and special
| characters?
|

Check Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html#TwoWord

(E-Mail Removed) wrote:
>
> Hi,
>
> I have three levels of dependent lists.
>
> I have restricted data entry using validation lists.
>
> User can select Country from the first list.
>
> This then dictates what they can select from State
>
> This then dictates what they can select from Region
>
> The problem is that I can only define the named lists with one word
> and its not very pleasing to the eye when the user sees
>
> South_east_precinct
>
> how can i allow the defined lists to have spaces and special
> characters?

--

Dave Peterson