How to apply text/layout formatting to a query?

[mpatel]

I notice that when I make a report I don't seem to have filter options available to me anymore.


However when I make a query, I don't seem to have any kind of basic formatting features (i.e. if I want to colour code a specific field).

In my current situation, I would need certain fields in my query logically grouped together (colour coding each logical grouping with a certain colour would be ideal), but at the same time I need to be able to use filters as I please.

Is there any way to have filtering and formatting capabilities at the same time?

Forgive me if there's an easy answer I'm overlooking, I'm new to access.

[CJ_London]

Not sure what you mean by filter options In reports. If you right click on a textbox, you should get a dropdown menu to enable you to filter unless you have turn off shortcut menus

queries are viewed as datasheets, they have no formatting capabilities other than formatting numbers/dates (unless you mean all columns). In a datasheet form you can use conditional formatting on the controls to affect color. And you can use a datasheet form as a subform to a report.

[ssanfu]

I notice that when I make a report I don't seem to have filter options available to me anymore.

You can have your filtering option(s) on a form, then open the report using (in this case) a button named "DoRpt":

Private Sub DoRpt_Click()
    Dim sWhere As String

    sWhere = "MyField = " & Me.Category
    DoCmd.OpenReport "Report1", acViewPreview, , sWhere
End Sub