Reversed columns order on split form

G

GaelicFatboy

Registered User.

Local time

Today, 11:49

Joined

Apr 17, 2007

Messages

100

• Aug 19, 2010

• #1

Hi everyone,

I'm running Access 2007 with Windows 7 and I've run into a problem with a split form where the datasheet at the bottom of the form is now showing the data columns in reverse order with the columns reading from right to left instead of left to right. I have the form orientation property set to "left to right" as this has been untouched.

Does anyone know how to get the form to behave properly?

Cheers

D

 

Trevor G

Registered User.

Local time

Today, 11:49

Joined

Oct 1, 2009

Messages

2,361

• Aug 20, 2010

• #2

GaelicFatboy said:

Hi everyone,

I'm running Access 2007 with Windows 7 and I've run into a problem with a split form where the datasheet at the bottom of the form is now showing the data columns in reverse order with the columns reading from right to left instead of left to right. I have the form orientation property set to "left to right" as this has been untouched.

Does anyone know how to get the form to behave properly?

Cheers

D

Click to expand...

D can you upload a sample and indicate which form to look at.

 

G

GaelicFatboy

Registered User.

Local time

Today, 11:49

Joined

Apr 17, 2007

Messages

100

• Aug 20, 2010

• #3

I've attached a database with the offending form. All the datasheet columns are back to front, namely the Pipe # column should be over on the lefthand side and not the right.

I've compared all the properties for this form with a backup copy and there are no visible differances in the form properties between the two copies

Cheers

D

 

Attachments

• Database1.accdb

  480 KB · Views: 233

Trevor G

Registered User.

Local time

Today, 11:49

Joined

Oct 1, 2009

Messages

2,361

• Aug 20, 2010

• #4

D,

I looked at the database and the query then create a new split form based on the query and it shows the fields in the correct order.

I haven't checked the properties thoroughly but it looks as this is what you wanted.

See attached (form name I have added 1 at the end)

 

Attachments

• split.accdb

  524 KB · Views: 188

G

GaelicFatboy

Registered User.

Local time

Today, 11:49

Joined

Apr 17, 2007

Messages

100

• Aug 20, 2010

• #5

Cheers Trevor,

I'm able to get the form working properly again by importing the backup and modifying to include the addition buttons and code. The bit I'm unclear about is what happened for the colums to be swapped. I'm going to be adding controls and a considerable ammount of code to this form then copying its format another seven times for similar applications so I need to be confident that it'll behave and not need restructuring if I add say a comand button.

I must say I've never had this problem before, but I've only been using 2007 this year, prior to that it was 2003.

Cheers for your help.

D

 

K

KMP585

New member

Local time

Today, 03:49

Joined

Dec 29, 2011

Messages

1

• Dec 29, 2011

• #6

I just encountered the same problem and was able to fix it by restoring my Tab Order. I don't know why it happened, but this seems to have worked.

 

S

SpaceEd

Registered User.

Local time

Today, 03:49

Joined

Nov 3, 2011

Messages

12

• Mar 19, 2012

• #7

Hi KMP585,

I've been experiencing the same problem. So you're saying when you "Auto Order" the tab order again and then reset, it worked for you?