Subform Fields out of order

[Guest]

I created a Query based on a Child Table so that I could have the data
presented in chronological order in a subform. I included all the fields from
the Child and linked the Child to the Query ... PKey to PKey. I changed the
record source on my subform to the query and the information is ordered the
way I want but....

The fields (datasheet view) are out of the order I want. They are correct
left to right on the subform...in the query...and on the table. What am I
missing?

On a less important note, I have reformatted all the fonts (MS Sans Serif 8)
in the table, overall datasheet properties and on the subform but the
datasheet view fonts remain unchanged (Ariel 10).

Thank You.

 

[Guest]

By clicking and holding at the top of the field name in datasheet view you
can move the fields to what ever position you like.

Not sureabout the fonts tho

 

[Guest]

Thank you on the field order......

Anyone have an idea about the fonts?

 

[Guest]

Not sure exactly what you mean but i think when you are in datasheet view
going Fromat > Font and changing the font there. That will change the font of
the entire datasheet.

enrico

 

[John Vinson]

I created a Query based on a Child Table so that I could have the data
presented in chronological order in a subform. I included all the fields from
the Child and linked the Child to the Query ... PKey to PKey. I changed the
record source on my subform to the query and the information is ordered the
way I want but....

You do not need to link the child table to the query on the child
table. JUST USE THE QUERY.

The fields (datasheet view) are out of the order I want. They are correct
left to right on the subform...in the query...and on the table. What am I
missing?

On a less important note, I have reformatted all the fonts (MS Sans Serif 8)
in the table, overall datasheet properties and on the subform but the
datasheet view fonts remain unchanged (Ariel 10).

Don't confuse data *storage* with data *presentation*. Your table is
not stored in *any* font. Your table contains only the data, as ASCII
bits and bytes.

Just set the font for the Form or Report or Datasheet in which you
want to present the data.

John W. Vinson[MVP]