Limit To List - First Coloumn

[Guest]

Hi All,

I am pretty sure that you will all tell me that this isn't possible but i
thought i would have a try anyway.

I have a datasheet form that as a cascasing combo box, programmes that
generates the contents of the activities combo box. I was wondering if there
was a way to not have to show the id (bound Coloumn) in the activities combo
box but show the name of activity instead, or is there a nicer way of showing
both remembering that this is in datasheet form?
Thanks for all your time

Tanya

 

[AccessVandal via AccessMonster.com]

Hi Tanya,

Yes, you can.

Use the "Column Width" property. something like "0";1";1".....
where "0" is the first column/field you want to hide. just use the "0" if you
want to hide other column/field.

 

[Guest]

Hi AccessVandal
Thanks for replying so quickly, i dont' think i was clear enough in my
question. because of the cascading combo boxes i have set the activity combo
box to limit to list = "No", The problem is that the bound column has to be
visible for the cascading list to work it seems and i was wondering if there
was either a way around this or a nice way of showing all the info?

sorry i still dont' think im being clear enough but am down with the flu 8-(
tanya

 

[AccessVandal via AccessMonster.com]

Hi Tanya,

Sorry about the “Column Width†mistake.

Try this, set the “List Width†only to show the “Descriptionâ€. Instead of
“ID†as the first column/field, put it at the last column/field , for example,
if each field is length is 1â€, say you have 3 fields..so, total of 3â€. Set
the “List Width†to 2â€, so you have the “ID†field hidden.

Select ID, Description, PartType From Table1
To
Select Description, PartType, ID From Table1

Set the “Bound Column†to 3 in this case. This will “ID†Bound the data into
the field.