Search results

Thank you for your response. Not sure which value is considered a temporary value. The check box field holds the active/inactive status of the client and will always be an identifier of the client. The checkbox only stores the -1 or 0 (True or False), so I am not sure what you mean by "store...

I have a field that is populated by a yes/no check box. This field tells whether a Client is active. I have a report that lists all clients and corrosponding Info. I have a Radio Button Box called "Active Client Button" with three radio buttons, this box gives the user the option of runing...

Never got the above to work. I have changed up my report a bit but still have a problem with alternating colors I am now using a subreport to list the payments, How do I get the backgrund color of the subreport to change colors with the detail section of the main report when it alternates...

I found a solution presented by Allen Browne which is posted in many forums but it does not have the desired results when I try it. If you want to alternate the color for entire groups (not for each record), you could do that with a combination of Running Sum and either Conditional...

AccessMSSQL I tried your code and coud not get it to work. I have attached a screen shot of what I have entered. The report opens in "Report View" but gives a "The expression On Format you entered as the event property setting produces the following error: Ambiguous name detected...

Re: Need alternate color in both header and detail tpuhlig Nice idea but could not get there: Group and data are generated by a query and don’t see how to add an odd/even field in a way that will assure the data is presented in alpha/numeric order and still have alternating shades. I’m not...

Re: Need alternate color in both header and detail I think what I am looking for is some code that will paint each detail section the same shade as its group header. And have the group header alternate shade, either by using the properties or code that would preceed the code telling the detail...

Re: Need alternate color in both header and detail Thank you for the quick reply. I have done as you suggested and the results are that the detail records alternate color within the group. This is way to many shading lines and looks very confusing. My hope is to present each Group and its...

I want the Group Header, and the Detail Section for that header, to be the same color, and for both to alternate for each change in the group header. I am not looking to have each detail record alternate. I need the GH and DS to alternate in sync. Any suggestions? Thank you.

I have an [Equipment Table] with 3 yes/no fields. The first field is [Send to Vendor]. This is check when a piece of equip. needs to be sent for repair. The second field is [Sent to Vendor]. This is checked when the piece is sent. The third field is [Returned]. This is checked when the...