I'm trying to set the LinkMasterField and LinkChildField properties of a subreport with VBA (using Access 2003), but I'm encountering the error: "Object does...

I have a report that looks like this.............................. Date1 Date2 Date3 Part 12345 Planned 200 300 ...

I created a report and I am trying to use conditional formatting on an expression. My expression show the variance between two numbers and I would like the...

I have an access database which has some data fields displaying a background color in the text box that is dependent on the data value. I.E. When the data is...

Hello, we have some code in detail_format which re-sizes a report. if it is previewed and then printed it does not work, even though the preview is fine. How...

I need to add up the number of actual dates worked at the end of the group, so that i can show how qty per day between a date range. Everything is perfect...

I have a column in my report that adds a start time and an end time column and it gives it to me in minutes. When I try to create a grand total of the total...

"Debba" wrote: In a report, how can I code a textbox to hide on the report if a second textbox is populated? in other words, I want the field name...

I have a report in which I want negative numbers to be displayed as -#,### in RED. The remainder to display in BLACK. What is the Format property entry I need...

Hi, I use RTF2 control in my application, but I need to ovver users only limited formatting options (B, U, I, background color and lists). So I Need to...

Looking thru these posts and not quite figuring out the best way to do what I'm trying to do. I'd like to create a report (that measures analyst productivity)...

Hello, I have to queries, feeding two separate reports. One report is being used as a sub report for the other: Here are the queries: SELECT Address.,...

I have created a label report, but I would like to add a different color based on the "Records Series" field. Ie. any records assigned to ACC would be Blue in...

I have a client that recently upgraded to Access 2003 and have all the most recent updates. The margins on all of their reports are all screwed up and you...

Simple Question: I have a crosstab query. Is there a way to get Access 2000 to use these varying fields in a report? Or is there a way to use a crosstab's...

I am trying to set the the distance for the boxGrowForDate from the left with the following expression. The control however never moves as though...

Assuming this is to happen in the report's detail section, you could use something like this in the detail section's Print event: If Not IsNull(Me.RD)...

I have an invoice I need to print showing the sum of item amount in the report header. I can get the sum in details and footer, but not in the header. The...

I tried the group footer supression but found it did not work on a 4 column label print-out. Access inserts the footer on a column basis and the other three...

Hey all I'm using Count(*) in the Report Footer of one of my report to count each record in the Details section. I'm having a error messages coming...