Help for access table

  • Thread starter Thread starter U.K.Nair
  • Start date Start date
U

U.K.Nair

Why order of fields in design and datasheet views different? Everytime I drag
and make them same but when I open next time it is again different. Please
help me.

email: (e-mail address removed)
 
Why order of fields in design and datasheet views different? Everytime I drag
and make them same but when I open next time it is again different. Please
help me.

email: (e-mail address removed)
Click to expand...

Are you referencing a table or query? I suspect you're dragging
columns around in datasheet view...

You should be viewing your table with a query; as such you can display
the results any way you'd like. The order should remain consistent in
both design and datasheet view (unless you've modified the datasheet
view independent of the design view, in which case I'm unsure how to
reset the datasheet properties).

If you can afford to, create a new query and adjust the field settings
there, leaving the datasheet to merely display the data.
 
When you close the datasheet view does it ask you to save the changes?
If so, say yes to save the changes in the display format. You are not
saving changes in the data.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top