Search results

Is it possible to combine the Is Null code as advised by vbaInet and the system advised by sxscheck, because being null would be better than simply not being visible Would the item being null be better than being not visible? I assume that if it is not visible then the field still takes up...

I have just tried changing the label to a textbox, but I can't get around the control source element - so each time I try to make this new textbox look like a label (ie give a title/header to the subsequent actual textbox) it either uses the relating info (because it uses the control source) or...

I think that I see your point... I use a form to collect/type up the info and then want to print out a report from a single record, so each report should (will) only show each label once and with a single textbox linked to it, eg Report for Record 1 Label 1 Textbox 1 with info Label 2...

There are roughly 55 textboxes and labels and I want it to print out on A4. It also needs to roughly match a predetermined format that has nothing to do with Access!

I do this with my reports and forms (if I understood your message)... you need to play with your code a little so that the code for your report button looks a little like this: Private Sub YOURBUTTON_Click() On Error GoTo Err_YOURBUTTON_Click Dim stDocName As String stDocName =...

Er... thank you, but... I can't remember whether I used the report wizard with a columnar or tabular set, but enough to say that it is highly customised - the field labels sit just above the textbox, within the Detail section of the report, eg: Title Label Text box with the info I think...

I have seen a few posts about making different fields disappear, but this isn't my problem - if the (textbox) field is empty then it doesn't show up on my report; however, the textbox label remains. The report contains over 50 textboxes (plus labels), so if the textboxes don't contain info then...