Query Formatting in Access 2010

Does this Have to be done in Datasheet view?

You did not post any details on how you:
"setup the color to highlight every other line in datasheet view and some other little things."
...so I can't be sure what you are asking for is possible.

For example, Access can have default template Forms or Report, ...not queries.

Depending on what exactly you did, AFAICT, this can all be done in a report.
Create a new blank Report and set all your options/settings.
Then name the report:  rptCustomTemplate1
Then in the Database Options-->Object Designers-->Form/Report Design View-->Report Template
Type in: rptCustomTemplate1

Compact/repair the DB and create a new report in design view.
It will have your custom settings.

JeffCoachman

Thanks for your reply Jeff.

Yes, it's the Datasheet view for the query, not on a report.

Again, I don't know of any way to create a "Design template" of a query.

Will you be posting the specifics on:
    "setup the color to highlight every other line in datasheet view and some other little things."
... I am still at a loss as to what this means specifcally

I don't know how re-wording the question will help....
But I leave that to you.

Jeff

If you have Access 2010 go into Datasheet view on a select query.  Select the Home tab and you will see the formatting options I mentioned.  Once I make all the changes I want, my actual question is how to make it so these changes will be seen in all select queries in datasheet view ("My question is, how can I save this as a default for all other queries.").

>> Will you be posting the specifics on:
    "setup the color to highlight every other line in datasheet view and some other little things."
... I am still at a loss as to what this means specifcally
See attached screenshot.  I already know how to do this, so this is not what I'm asking for help with.  How do I save these changes for future use is what I'm asking for.

>>I don't know how re-wording the question will help....
It didn't seem like you understood what I was talking about, so perhaps re-wording it would be more clear.

If you have any suggestions, please let me know.  I thought this was a dead question though, so that's why I was going to delete it.  But if you know what I'm talking about now and know how to do it, then I'd be happy to hear it.
Snapshot.jpg

>>1. I don't see a way for this to be done.
I didn't see a way either, hence the question :-)

>>2. I guess my question was why this had to be in a query specifically.
I search through the data in my tables a lot for ad hoc questions by users.  It's very handy to have the totals added (not necessarily for a specific field, but just added to the bottom, so I can select as necessary) and for every other row to be highlighted.  My tables have millions of records, so it's nice to differentiate between the lines, especially when there are many many columns in each table.  (Note: I did not design the tables, they're linked tables to an ODBC using SQL Server).

I didn't want to use a form, because I'm looking for something quick and dirty, but I didn't want to have to do it every single time I look at any query in datasheet view.

If it's alright with you, I'll leave this open for a day or two and see if any other experts pipe in, if not I guess the answer is it can't be done, and I'll give you the points for your comment http:34954771

Thanks again for taking a look.

One change:
I search through the data in my tables

Should be:
I search through the data in my tables by using queries so I can aggregate the data

<If it's alright with you, I'll leave this open for a day or two and see if any other experts pipe in>
Sure, no problem.

;-)

Jeff

broomee9,

If I'm reading your question right, you are simply trying to alternate colors (highlighting) in your datasheet views of queries, tables, etc.

This works in Access 2007, and I imagine that Access 2010 is a slight variation:

- Click the office 'blob' in the upper left-hand corner of the Access window
- Click 'Access options'
- Goto the Datasheet options
- Change the "Alternate Background Color" setting to whatever you want your highlight color to be.

This persists (ie it is 'saved'), and it applies to all datasheet views in your database.

mbizup - I took a snapshot of the Datasheet section and I don't see the Alternate Background Color.
Screenshot.JPG

OK, thanks for the explanation.  I split the points mostly because both answers were it can't be done but mbizup, your answer showed at least one piece that can be done.

Thank you both.