Moving fields in Subform?

[Gumby]

I have created a subform with the fields in the "datasheet format". The order of the fields is not correct. What I mean is that some fileds should be before the other fields. How can I move the fields around.....I looked at the properties of the subform but that didn't help.

Any help would be greatly appreciated

Thanks

 

[Jeff Bailey]

A good way would be to create a query with the columns in the order you want and base the sbform on this query.

 

[Gumby]

Jeff,

I tried that but still that didn't work. I am using SQL server database and my subforms are in Access. I created a view in SQL server and called that view in the subform "Record source" properties.....that didn't help. In the view I entered the fields as I wanted to appear.

Is there any other way?

Thanks

 

[Jerry Stoner]

Ive run across this before and the best solution Ive found is to "cheat" by using a continous form instead of datasheet view then format it so it looks exactly like a datasheet view. Gives a lot of flexibility you dont have in datasheet view(ie. you can change field order and custom captions and conditional format).

 

[Rich]

Why not just click on the column header and drag the column to where you want it?

 

[Gumby]

Thanks Rich. That worked. I actually tried dragging the column header to the desired position before but it didn't worked. Its kinda tricky. Oh well.... I tried again and it did worked.

Thanks!