Setting Field positions

[George]

My database consist of a main form "Orders" and a subform "Order Details". The subform has several fields including: Quantity, Unit Cost, Product Code, Description etc.



Problem: I want "Product Code" to be the first field so I arrange it like that in the design view, but it does not appear like that in the form view; the Quantity stays as the first field. I have even tried shifting the fields around in the form views and this works but when the form is closed and reopened the "Quantity" field reverts to first position.

Setting the field width is the same problem it revert to original column width.

would be grateful for some assistance

[June7]

Is form in Datasheet view mode?

[George]

thank.

Yes it is in datasheet view

[CJ_London]

datasheet column positions are not affected by the form design. To change the order of columns in a datasheet, open in datasheet view, click on a column heading and drag to the position required. Then save the datasheet. If it is a subform, it is better to do this from the form itself rather than via the main form subcontrol

[George]

Thanks. I have been trying that before and now but it just doesn't work. Do you have any other suggestions?

[June7]

The technique works for me. I have done it from the subform container.

If you want to provide db for analysis, follow instructions at bottom of my post.

[CJ_London]

it works for me as well, but if you want to set it in code take a look at the columnorder property

https://msdn.microsoft.com/en-us/lib...ffice.11).aspx

You'll find links at the bottom for also setting widths, hiding and freezing columns and setting row heights

[George]

Thanks to all of you for your assistance, however I think I have stumbled across a simple solution:

Open the form in form view rearrange the fields as desired, by dragging. Open the property sheet. Click on any of the columns until the property sheet display changes to show a list with column count. change the column count. In my case I change it to 6 from 1 - Don't know if the number matter though. And that all. The field tick where you have them.

[CJ_London]

As suggested in post #4