[AccessD] Table Row Source

Dale,

There is no need for the ""s.  This is how I would do it:
0;Administrator;1;Supervisor;2;User

However, just out of interest, I tried it in Access 2003 and Access 2007 
with the way you did it:
0;"Administrator";1;"Supervisor";2;"User"
... and it worked fine for me.  So not sure what your problem was.

Regards
Steve


--------------------------------------------------
From: "David McAfee" <davidmcafee at gmail.com>
Sent: Friday, September 18, 2009 6:54 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Table Row Source

> "0";"administrator";"1";"supervisor";"3";"user"
> and set your columns to 2
>
> On Thu, Sep 17, 2009 at 11:38 AM, Dale Kalsow <dkalsow at yahoo.com> wrote:
>> I was wondering if in a table if I set the row source value to Value 
>> List, how in the row source do I specify 0 = administrator, 1 = 
>> supervisor, and 3=user.  I have tried 
>> 0;"Administrator";1;"Supervisor";2;"User"
>> Which is how a form would handle it but that does not work.
>>
>> thanks!
>>
>> Dale
>>