Link to home
Start Free TrialLog in
Avatar of NettieEckenrode
NettieEckenrode

asked on

Remove whitespace characters form desplay of text box data in report

I have a text box on my report that dispays data from a ntext field in SQL 2005.  I need to remove the tab and returns from the display.  trim does not seem to work.  is there a function within Visual studio 2005 that I can use to strip these out?
Avatar of appari
appari
Flag of India image

try

yourvariableName = yourvariableName.replcae(vbtab,"").replace(vbcrlf,"")
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NettieEckenrode
NettieEckenrode

ASKER

Perfect...thanks for your help