Click here to Skip to main content
15,881,173 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello:

First I should apologize for the ambiguity in my last post.

http://www.codeproject.com/Questions/108939/Changing-Table-orientation-to-Right-to-Left-at-run.aspx[^]

Orientation of table is a property could be set via Access Software 2007 -> Design View -> Property Sheet.

The property has two options. Right-to-Left & Left-to-Right.
Left-to-Right is the default value and is used for language like English and so forth. But If Right-to-Left is selected, the first column appears at right most part of table and second column comes next to it at left and the last column stands at the left most part of table. This option is more suitable for languages like Persian and etc. which starts from right side of sheet and continues to left side. (Once one changes the orientation to Right-to-Left in Access, the explanation above becomes clearer. Lets try it please)

With the explanation above I repeat my question asked before. I wish I could have got my meaning across.

In a program I need to create a table at runtime. I know how to define its fields by using the code below, but the result is Left to Right oriented (as it should be following its default pattern). What I need is to change the orientation to Right to Left at runtime. Could you please help me?

Thanks a lot

Sql_Command = "CREATE TABLE myTable" +
                                     " (" +
                                      " ID int IDENTITY(1,1) PRIMARY KEY," +
                                      " Name Text(10) ," +
                                      " Age number" +
                                      " )";
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900