Hi Bill
Aha that's interesting!
No the form is not based on a query - it is based on a table.
However, I went to table design and moved the field to the position I want it in. I then displayed the form in datasheet view and the columns hadn't moved but this time when i moved it and saved it - it stayed where I want it.
Not sure I quite understand why but it seems to have solved my problem (please feel free to explain)
Thanks for nudging me in the right direction
Phil
________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, 9 July 2013, 19:24
Subject: [MS_AccessPros] Re: Moving columns in datashett view
Phil
You're right. It should open to the last layout unless something is changing it. Is there a query as the RecordSource? If so, arrange the fields in the order you want them within the query.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com/
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com/
--- In mailto:MS_Access_Professionals%40yahoogroups.com, "pdk444444" <pdk444444@...> wrote:
>
> Hi
>
> I am trying to move a column in datasheet view but when I save it and then reopen the form again (it defaults to datasheet view), it reverts to its original position.
>
> I have many forms that I use in this way and I can move cols and save them and they stay in the new position.
>
> What could it be about this particular form?
>
> NB no subforms are involved and the form is opened via a macro in order to default to datasheet view
>
> I would appreciate any help
>
> Phil
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar