Jumbled Up data columns

[qianlong]

Hi, I had created a database with forms for easy entry and viewing of information. After everything is done, the database works fine until I started to hide some columns as I only wanted to print certain information. After using the database, I save and closed it without unhiding the columns that I had hide previously.

Here is where the problem occurs. I access the database the next day and unhide the hidden columns. To my dismay, the columns together with their information has rearranged themselves. For example the title of the columns in my database suppose to be in this order (Customer's Name, Address, Tel No., Country) however, now it has rearranged itself to (Customer's Name, Country, Tel No., Address). All the data is still intact except that the columns had rearranged themselves. However, when I preview it, the arrangement of the columns are in the correct order. Well, please let me know how to solve this problem. I would like to restore the database to its original form urgently. Redoing the whole database again is definitely not a solution.

Thank you in advance.

 

[WildHare]

Relax. The order of the columns in a table is of no importance. As long as the DATA values for everything are correct, it really doesn't matter if the table reads "custno, custname, state, city, zip" or "zip, state, custno, custname, city".

You can access the data in a query in any sequence you want.

It's probably not a wise idea to access the data directly through a table datasheet, as you've found out, so don't worry about the order of the columns.

Jim
Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm