[AccessD] Table Row Source

I would suggest you use ALL quotes on ALL values (including the numerics) or
None on Any
BUT
If there is a space in the non-numeric values, use quotes on all.
The value will still come through IIRC

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: 17 September 2009 20:12
To: Access Developers discussion and problem solving
Subject: Re: [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
>>
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com