Hi All
Is there any way of determining how text is handled when it is say pasted into a text box.
I have a text box on a form which users either type or paste into.
The problem is that when users paste into the text box it can sometimes be distorted and can cover a large space depending what way it was typed into the original document.
Please help
Thanks

Brendan Bartley

__________________
Brendan Bartley

You can use the After Update event of the text box to do some validation.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Is there a code I could user to change the text format
Thanks

Brendan Bartley

The code depends on what exactly what you want to do. If you just want to change the text color and/or font, just change the textbox properties. If you want to change font type, bold, italics, color, etc. only SOME of the textbox text then you're getting into rich text formatting that Access alone does not provide.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Users text items into the text box this can be e-mails etc the format of thetext can be all over the place
What I want to do is to remove the balnk spaces


Brendan Bartley

Look up the help for the TRIM() function and also the REPLACE() function. Perhaps you can do a combo of TRIM and something like REPLACE(Me.txtMemo, " ", " ")
where you kill every double space and replace it with one. Change txtMemo to the actual name of your field.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division