Recent content by russellito

mmm. i think so. you just want blank tables, queries and such? is there a fast way to do that?

OK, so I had 3 sets of 9 text boxes that were going invisible. that create alot of space, and they were going invisible. But what I think has happened is that the space in between the boxes created the space that pushed the report footer onto the next page. I squished all the boxes together and...

Hi, I need the detail section in my report to shrink to fit only the visible boxes. Is that possible? I have the Can grow and Can shrink options set to yes, but it still leaves blank space when the said text boxes are invisible. help please?

Thanks. That works, it makes the boxes invisible. But Still, the detail section doesn't shrink. There is still lots of white space. I changed the event timing to report load instead of detail format. didn't work the other way.

I want to run a report with a date range, the query already asks for the beginning and ending date. Can I display those parameters on the report in a text box?

I guess I need you to walk me through it a little more. I did this, cause i just need the objects to be invisible not the whole detail section. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim ReceiptRetainment, UTSalesTax, BusinessPurpose, Review, Approval, Notes...

ya, all of the boxes and the detail section have can grow/shrink to yes. But there is still lots of white space. The detail section size is set to certain length, is that the problem? I even set auto height to yes. Still lots of space... I know this has deviated from the code topic, but I still...

Ok, forget all that if it can't be done. But can I set the Iif not true part of the expression to make the text box invisible? I end up with a big blank area if they are all false.

Nevermind, I tried it, well, I tried this =HtmlEncode('<b>this</b> is text') and it just brought up nonsense characters for the html tags... whats the HtmlEncode function for then?

won't this work? =IIf([Receipt Retainment]=True,HtmlEncode('<b>Receipt Retainment:</b> An original, itemized receipt was not retained for the following transaction(s):'),'')

Fantastic! That works great! What I didn't use the Me. though. I used this =IIf([Receipt Retainment]=True,'Receipt Retainment: An original, itemized receipt was not retained for the following transaction(s):','') What i'd like to do now is bold just the heading of the text. Is there a way I can...

I"m sorry, but that doesn't make a lot of sense to me. I can't tell what part of that is code and what isn't. I also don't know how to define the variables. Help there too?

I want to put it into the detail somewhere. Whether its a text box, label, whatever is the best.

I am building a report, and I'm stuck. My access knowledge comes to an end with VBA, and I think thats what I need for this problem. I'm trying to build a report that changes according to values in the source query. There are 11 yes/no fields, and, I want the report to enter specific text if...

Hi, this is probably a question with an easy answer, but i don't know what to do. I have 2 tables Heirarchy and cardholder. heirarchy has 4 fields one of which is an autonumber primary key. I need to move that autonumber key to the cardholder table as a foreign key. Cardholder table already...