Search results

That measurement, Ken, is what Properties shows for the height of the Detail section. The thickness of line that I'm using is 'hairline'. I can't think what is causing the irregularity - I suspect it is to do with something I should state in Properties. I've gone through it a few times, but...

Sorry, Ken, it's restricted stuff. If there's a chance, I'll use some mock info. Course there won't be a chance today. But I'm working on this early in the week, and if I haven't found an answer - and you don't mind looking - I'll do that then. Pity this week's reports have to have this strange...

Rich (it must be your birthday soon) ... the height says 0.4583". I've not touched the height of the detail section, by the way. The layout is Landscape.

Hi Ken No, it was close to the fields, and I butted it right close, and on the right-click I set it for "To Grid" and now it gives a line under the first row, misses one, prints a line under each of the next 4 and misses one, and then puts it under each of the next 3, which brings it to the...

You've helped me too, MonkeyTunes. Many thanks.

How do you have a line between each record on a report please? I used the line-tool to divide each record with a line, but it underlines one record, then two, then one ...

Thanks, MoP, for pointing that out. All noted. Cheers

Yes, thanks, phillipjp390, working well now. It's being questioned why I wanted to use code when I had MoP's perfectly good expression. I wanted to know how to do it in code - it seems a better approach, though I may be wrong. (Probably am.) The expressions by MoP and bjackson are excellent...

Good to hear from you again, bjackson. No, I haven't but I will try. Thank you. And thanks, MileO-Phile. I'll add the variation to the collection.

Lexcerm, yes, that is the just sort of thing I had in mind. It does the job perfectly, and I'll use Mile-o-Phile's in a query - and thanks to you and MoP and Ken and philljp390 and Rich, et al, I am better educated. And happier! (It's holding onto all this knowledge that becomes the challenge.)...

Yes, I saw that, Ken. How crazy, sorry. However, unfortunately it still won't go. (If I can change files to include that correction, I will.)

I know, MoP, but I can't see why it won't work by coding ... and thought I would take advantage of the collected brains. I've put the great IIf statement of yours into place this very moment, and it works like a dream. (A good dream, I mean.) Thank you.

Your help is appreciated. It doesn't want to respond to your good advice. Here's a very basic stripped-down model, hoping that you might spot the error. TIA

If only, but unfortunately not. This is so crazy. I've spent, well, quite a long time on what should be so simple. Even so, any other ideas would be welcome. Many thanks.

PhilpJP390, it looks promising, but maybe the hot afternoon is getting to the program as well because on your line Me.txtResult = NowDate - Me.txtdate1 & " day(s)" I receive this error message for Me.txtdate1 (which now has my field's name) "Method or data member not found" I wonder if this...

Another dynamite IIf job from you does the trick. (The calculation doesn't want to work from the code, no matter what I do.) So I'll use your IIf on the form, and on the query that feeds the report. Hats off to you, MoP. Wish I could aford you, wish I had half your knowledge. (Thinking of...

You see, the User wants to see the total on the form, going from record to record. Every week, I need to print a report based on the total of days.

For a query for a report. These day totals are the crucial part of the report ...

Sadly, no. It chops up your statement, in fact. Is this because it is bound to the field? Only it has to be to record the number of days.

Thanks very much, MoP - but it doesn't want to oblige. Nothing at all shows in txtBox4. Could it be because I am using "Private Sub txtBox4_Change()"? (I mean, not even the message box appears.)