I am self taught
, so there is probably something very simple that I am overlooking, but here is the problem.
I have a report that is used for mailing sorted by postcodes. I have (by code) managed to assign a sequence and page number to each record and used the sorting and grouping levels on the report so that when the page is cut into 3 it does not disrupt the postcode sort.
The sheet is 3-up with preprinted colours and I need to add multiple text boxes with various information that will fit exactly into the different coloured spaces. On the left are 5 text boxes and on the right are two text boxes and two images.
The mailing name and address is on the right.
The text boxes on the left have various text concatenated from fields and some have to be "bold". I have figured out how to "bold" these using a rich text box and html tags.
The name field on the right also needs to be bold, but I have used the below CanShrinkLines function on the address textbox (which concatenates 5 fields) to get rid of blank spaces in the the address and can't use this function in a rich text box for some reason, So have the name in a separate textbox (rich text) and use the html tags to bold. this rich text box is set to CanGrow, as it needs to wrap if the name is too long.
Public Function CanShrinkLines(ParamArray arrLines())
Dim x As Integer, strLine As String
For x = 0 To UBound(arrLines)
If Not IsNull(arrLines(x)) And arrLines(x) <> "" Then
strLine = strLine & arrLines(x) & vbCrLf
End If
Next
CanShrinkLines = strLine
End Function
This is all working very well.....however, the fields on the left need to stay in an "Absolute" position and every time the rich text box on the right "grows", it shunts the left boxes down and up.
I have tried setting the text box position with code on the reports onOpen event, but that doesn't seem to work either.
ANY help with this would be so much appreciated!!!
, so there is probably something very simple that I am overlooking, but here is the problem. I have a report that is used for mailing sorted by postcodes. I have (by code) managed to assign a sequence and page number to each record and used the sorting and grouping levels on the report so that when the page is cut into 3 it does not disrupt the postcode sort.
The sheet is 3-up with preprinted colours and I need to add multiple text boxes with various information that will fit exactly into the different coloured spaces. On the left are 5 text boxes and on the right are two text boxes and two images.
The mailing name and address is on the right.
The text boxes on the left have various text concatenated from fields and some have to be "bold". I have figured out how to "bold" these using a rich text box and html tags.
The name field on the right also needs to be bold, but I have used the below CanShrinkLines function on the address textbox (which concatenates 5 fields) to get rid of blank spaces in the the address and can't use this function in a rich text box for some reason, So have the name in a separate textbox (rich text) and use the html tags to bold. this rich text box is set to CanGrow, as it needs to wrap if the name is too long.
Public Function CanShrinkLines(ParamArray arrLines())
Dim x As Integer, strLine As String
For x = 0 To UBound(arrLines)
If Not IsNull(arrLines(x)) And arrLines(x) <> "" Then
strLine = strLine & arrLines(x) & vbCrLf
End If
Next
CanShrinkLines = strLine
End Function
This is all working very well.....however, the fields on the left need to stay in an "Absolute" position and every time the rich text box on the right "grows", it shunts the left boxes down and up.
I have tried setting the text box position with code on the reports onOpen event, but that doesn't seem to work either.
ANY help with this would be so much appreciated!!!
