Split Form Orientation

[SpaceEd]

Hi,

I have a split form with several fields. Unfortunately, the orientation of the split form (spreadsheet portion) constantly reverses the orientation randomly when I navigate away and back to it.

I can obviously change this myself by going to the property sheet and resetting the Orientation back to "Left-to-Right." However, I would navigate away and back again, and it would randomly switch back to "Right-to-Left." I tried fixing this with VBA using the following code:

Private Sub Form_Load()

Form.Orientation = 0

End Sub

but then I get a "Run-time error '2136' To set this property, open the form or report in Design view."

Does anyone know what is causing the Orientation to randomly switch and reverse the column order? Or does anyone know how to permanently fix the split form in the "Left-to-Right" ???

[June7]

For one possible fix, review http://www.access-programmers.co.uk/.../t-197794.html

[Missinglinq]

Haven't looked at June7's link, but whenever things that are truly strange, odd or curious pop up, in Access, and this is certainly one-such occurrence, one obvious thing to consider is corruption! I suspect that you're going to have to re-create your Form to get rid of this phenomenon.

Hopefully you have a backup of you db file that pre-dates your problem!

Linq ;0)>

[SpaceEd]

Thanks for the responses.

June7 - Thank you for the suggestion. I actually did see that link and was the last person to post to it several months ago. Unfortunately, the users of my database have been experiencing the issue since then.

Missinglinq - While I really hope you are wrong, I suspect that could be the case.

That said, has anyone else been experiencing this problem?

[June7]

Oh, now see your user name on that thread.

Recreating the form shouldn't be so bad. Create a new blank form and copy/paste all the controls from the old one.

[Artist.Anon]

You can also try save-as, this fixes a lot of form corruptions.