Hello,
I am using access 07 and have some VBA code which puts some text into a memo field for me. It gets the text from various columns of a table.
Currently it produces text that looks like the below:
phil - hire - advanced
jonathan - lessons - beginner
claire - lift pass - local area
etc
Does anyone know of a good resource for info on code for formatting the text? So far I've discovered vbCrLf, that's it! What I'd ideally want is just to be able to line up the text into columns and also if there are any features I could use here (e.g. the option to line up to the right hand side of the words or to the left hand side?).
This will be a template email for billing guests so I'm just trying to work out how to make it look good. It needs to stay just as text for the way I'll be emailing it.
Any ideas on where to look to find out what's possible and what the code is?
many thanks,
Phil.
I am using access 07 and have some VBA code which puts some text into a memo field for me. It gets the text from various columns of a table.
Currently it produces text that looks like the below:
phil - hire - advanced
jonathan - lessons - beginner
claire - lift pass - local area
etc
Does anyone know of a good resource for info on code for formatting the text? So far I've discovered vbCrLf, that's it! What I'd ideally want is just to be able to line up the text into columns and also if there are any features I could use here (e.g. the option to line up to the right hand side of the words or to the left hand side?).
This will be a template email for billing guests so I'm just trying to work out how to make it look good. It needs to stay just as text for the way I'll be emailing it.
Any ideas on where to look to find out what's possible and what the code is?
many thanks,
Phil.