Sort Fields in Datasheet view

[DontKnow]

Hi Guys,

I have a subform in datasheet view mode and I want to change the order of
the fields. I have tried changing the tab index no, selecting the field and
moving to the desired position but to all no avail.

Does anybody know how to chjhange the position of fields within datashhet
view mode??

many thnks for your input!!

Cheers,

 

[Jack Leach]

Have you tried an SQL recordsource with the fields called out in the order
you want to see them? Not positive this wil work, but it's worth a shot.

hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[John W. Vinson]

Hi Guys,

I have a subform in datasheet view mode and I want to change the order of
the fields. I have tried changing the tab index no, selecting the field and
moving to the desired position but to all no avail.

Does anybody know how to chjhange the position of fields within datashhet
view mode??

many thnks for your input!!

Cheers,

If the subform is based directly on the table, it will reflect the table's
field order. Try basing it instead on a Query selecting the fields in the
order you prefer (and, if there are fields that you don't need, just omit them
from the query).

 

[DontKnow]

Thanks guys,

Fixed my problems!!

Cheers