T
Tech Guy
I have a form designed in Access that has text boxes, checkboxes, combo
boxes, and buttons. I need to be able to copy the first text box, which
is labeled Customer, to the clipboard. Then I want to add a blank line
on the clipboard after the contents of the customer field and then add
the contents of the next field which is PHA # and so on. Basically to
look like this in the end.
"Contents of 'Customer' field here"
"Contents of 'PHA #' field here"
"Contents of 'Contact' field here"
.....
In the end I want to email this block of info with Outlook Express to a
mobile phone.
If a field is blank when going through the rounds of copying I want it
to skip it. Right now if 'PHA #' were blank and 'Customer' contents was
"AT&T" and 'Contact' contents was "Bill", it currently looks like
this...
AT&T
AT&T <<<<<Line not supposed to be here if blank
Bill
Thanks in advance.
boxes, and buttons. I need to be able to copy the first text box, which
is labeled Customer, to the clipboard. Then I want to add a blank line
on the clipboard after the contents of the customer field and then add
the contents of the next field which is PHA # and so on. Basically to
look like this in the end.
"Contents of 'Customer' field here"
"Contents of 'PHA #' field here"
"Contents of 'Contact' field here"
.....
In the end I want to email this block of info with Outlook Express to a
mobile phone.
If a field is blank when going through the rounds of copying I want it
to skip it. Right now if 'PHA #' were blank and 'Customer' contents was
"AT&T" and 'Contact' contents was "Bill", it currently looks like
this...
AT&T
AT&T <<<<<Line not supposed to be here if blank
Bill
Thanks in advance.