Hey, im working with a receipt layout and trying to divide up a products descriptiontext into 2 lines if its longer then 24 characters.
my first solution was something like this:
If Row.Description.Length >= 24 Then
TextToPrint &= Row.Description.Substring(0, 24) & " $100"
TextToPrint &= Row.Description.Substring(24) & vbNewLine
else
TextToPrint &= Row.Description & filloutFunction(Row.Description.length) &" $100" & vbNewLine
end if
but that gives this result.
A product with a long na $100
me that doesn't fit
I cant figure out how to make a function to divide the description to look like we normaly see it.
A product with a long $100
name that doesn't fit
hope i made myself clear /:
would really appreciate any help.