Recent content by wallymeister

The actual code entered in Query Design Grid: Num_Format: IIf([Checks.CheckItemDesc]="BLOWER MOTOR","<font size=2>" & Left([Parts].[PartNum],2) & "</font><font size=3 color=red><strong>" & Mid([Parts].[PartNum],3,2) & "</strong><font size=2 color = black>" & Mid([Parts].[PartNum],5,2) & "<font...

Worked like a charm! Thanks so much. I knew there had to be a way. I tried UDF but it wasn't working for some reason. It was better done in Update Query anyway. Makes more sense. Again, Thank you! Wally

Thanks JHB for the reply My format is a little complex Like - 123456789 with Font size changing as well. But I will give this a try. Cheers Wally

Calling Access Gurus Hello again, Long time no see! I have a table that has a memo field set to RTF that mirrors another field. When a report prints and a certain condition exists I programmatically hide/Unhide the TxtBox controls to Print the RTF when I want to. I have an edit form that when I...

Galaxiom I don't know what happened here but I thought you were replying to my question but I see now that I got something screwed up. Too many windows open at once I suspect.

Thanks Galaxiom for your reply Question? Is there a way to use Rich Text Memo fields FORMAT property to automaticaly format the data that is entered or changed along the way. Here is a more real world situation that I have. PartNo field holds "HM54ZK001" text. I want Memo field to hold...

Hello guru's I'm back. Long time no see. I have just been asked to add a rich text memo field which I done. This memo field mirrors another field so that in a report for certain data I can hide unhide as necessary to display data like www.dixiedancekings.com Now, as I said there is another...

Hello Guru's Extraordinaire, Question? I have a report that prints each record on 2 pages, single sided. My customer wants to add generic images to back side of pages for all records. Is there a way I can pause the printing after odd # pages, print images on even # pages (I realize I have to...

Not on a regular basis but this application is used by different dept's that may or may not want to add an additional item to keep report from going to 2 pages. This may be temporary or permanent. The min lines per page is 36 and the max is 42. The ratio I'm calculating is to clean up the...

Hello vbaInet, No the frame is not bound to anything. Each radial button has option value of 36 thru 42. I want to find the highest value (42) via vba. In case I add options I don't want to have to re-code because I am using this highest number in a calculated variable. I can easily get the...

Thanks vbaInet, Yes the problem I was having was just that I couldn't use inches to set heights in vba needed (Twips = (Inches * 1440)) Got that sorted out, now I need to get the Max value in an Option group. Don't know yet if something like... X =...

Ok, but I know why the fields are not showing now. As I said in my last post the value of PartNum textbox is being set to zero. Rounding down to nearest integer from decimal value of .2111 I guess. So therefore it is invisible. I can't attach bmp files for some reason. I guess they need to be on...

Wait, I just realized that the value of FindBoxHeight is .2111 but adding .0104 makes it 288. Then Me.Text93.Height is 0 after so that explains why its not visible. But why won't Me.Text93.Height not accept .2111 value? Code examlpe FindBoxHeight = DLookup("[TextBox_Ht]", "ReportParameters"...

Hello Guru's Wally here again for advice and suggestions. I have a report that the user may from time to time need to add a detail section line to the report. Just to keep from having to print 2 pages so adding a line is desired. They will come to me and I will go in and change the TxtBox...

Yes, I realized that shortly after my last post. That would certainly be the way to go. Thanks Mr. B