microsoft.public.access.reports | Forum profile

  Can you tell us anything about your report? What is the height of the detail section? Did you check all the properties for something that might be causing the perceived double-spacing? -- Duane Hookom Microsoft Access MVP "Tina B" wrote: > how do I get my reports to print single space instead of double space? > > Thanks, > > Tina  

  Did you try Left([YourField],1) ? -- Build a little, test a little. "Brad" wrote: > We have an Access 2007 Report that current pulls many fields from a database > table. > > We need to add one additional field to this report, but we only want to > print the first byte of this new field. > > Is this possible? > > Thanks, > > Brad  

  On Nov 9, 2:04?pm, duanehookom <duanehoo...@gmail.com> wrote: > You can set the subreport control to invisible with code in the On > Format event of the main report section that contains the subreport: > > Me.srptControlName.Visible = Not (totalactualtime-targettime)/ > targettime<0.1 > > This assumes the name of your subreport control is srptControlName and...

  Anna, How about setting the Properties of the Text Box to Can Grow = Yes? Then the Text Box will self adjust to the characters within. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Anna" <Anna@discussions.microsoft.com> wrote in message...

  It is the Report Header. JR "KARL DEWEY" wrote: > Your orignal post said 'text box in the heading of the report' but here you > are saying 'BUT once I put a control in the title area I get prompted for a > parameter.' > > What version of Access do you have? Mine, 2007, does not have a 'title > area.' > > -- > Build a...

  Hugh, Where is this field that has the DLOOKUP( ) as the ControlSource? If it is in the detail section of the report, then it should use me.[Prov] just fine. If it is in a header or something like that, then it could cause a problem. Actually, I was going to recommend, as an alternative, modifying your query so that it looks like: SELECT T.Prov, T.Gender, T.Quantity, P.Province FROM (SELECT Left([Nat_Reg],2) AS Prov, IIF([Male] =...

  Thanks for the reply Marshall. I based my report on a query as you suggested and it fixed the page problem, down to 2 pages which is right. The query runs in 1 second, but the report still takes 25 seconds. Like I said, it must be because of the code in my On Open event as I am doing a lot in there. There are no grouping or sorting on this report at all. Here is the code in my On Open and see maybe if its anything in there. Private...

  Tracey wrote: >On Nov 3, 8:04?pm, Marshall Barton <marshbar...@wowway.com> wrote: >> Tracey wrote: >> >I have a question for my report. We used to only put target time and >> >actual time on the report. But recently my boss wanted to list more >> >information on the report. If the difference between actual time and >>...

  Frank - [A] should work. If not, I would check to see where your function is. Is it in a module that has public access? I assume your function call is something like: Public Function GetStringResult(ValA As Boolean, ValB As Boolean, ValC As Boolean, <etc.>) As String If so, in your report, you would use as the controlsource for your text field something like this: =GetStringResult([A],[B],[C], <etc.>)...

  I've identified where the error is occuring but I still don't understand why. Also, I mispoke in my second post the running sum is in the grouping footer next to the subreport (also in the grouping footer). So for one of my records it is picking up half the amount. It shows the total for the record to be $1000 but only adds $500 to the running sum. The record is the sum of two $500 amounts. It is not the only record with...