evergreean43
Technical User
I have a condition on my form update that checks for differences between my form textarea value and the value in my Access 2000 database.
It works 99% of the time but adds a space in the Form value on long url entries such as this:
The database value shows no space:
I have the form textarea wrap set to "hard" and if I turn that off or set it to "soft" the space addition goes away but I need the "hard" wrap on.
Please advise a way to correct this problem because I have tried the trim function, htmlcodeformat function and many rereplace attempts but none work.
It works 99% of the time but adds a space in the Form value on long url entries such as this:
Code:
[URL unfurl="true"]http://myserver/long/long/longlonglongurlhere/here_[/URL] page.cfm
The database value shows no space:
Code:
[URL unfurl="true"]http://myserver/long/long/longlonglongurlhere/here_page.cfm[/URL]
I have the form textarea wrap set to "hard" and if I turn that off or set it to "soft" the space addition goes away but I need the "hard" wrap on.
Please advise a way to correct this problem because I have tried the trim function, htmlcodeformat function and many rereplace attempts but none work.