How to remove single quotes i.e. ' ' ????

[vishwaskothari]

When we take some data of textbox or other controls from a FORM to DATAREPORT it comes with single quote.

for eg: ' vishwas '

I want that single quote should not be there

so how can i remove it from the DataReport ?

TIA

with best regards
vishwas

[debasisdas]

try to use the inbuilt replace function
Syntax
=========
[CODE=vb]Replace(Express ion As String, Find As String, Replace As String, [Start As Long = 1], [Count As Long = -1], [Compare As VbCompareMethod = vbBinaryCompare]) As String[/CODE]

[vishwaskothari]

try to use the inbuilt replace function
Syntax
=========
[CODE=vb]Replace(Express ion As String, Find As String, Replace As String, [Start As Long = 1], [Count As Long = -1], [Compare As VbCompareMethod = vbBinaryCompare]) As String[/CODE]

thanks dear

But its not working.

i m asking about the starting and ending single quotes, that are originally not present in the text, but when we take the text from Textbox to the DataReport there are those single quotes (Gaurding the text , dont know from whom !!!!!!!!! )

[Dököll]

thanks dear

But its not working.

i m asking about the starting and ending single quotes, that are originally not present in the text, but when we take the text from Textbox to the DataReport there are those single quotes (Gaurding the text , dont know from whom !!!!!!!!! )

This should help get it wherever it is:

[CODE=vb]

Dim s1 As String
s1 = Text6.Text

s1 = Replace(s1, "'", " ")
Text6.Text = s1

[/CODE]

It removes the single quote (') and adds an empty string (" ")Let's give that a whirl.

Text6.Text is your multiline textbox by the way.

Good luck!

[vishwaskothari]

This should help get it wherever it is:

[CODE=vb]

Dim s1 As String
s1 = Text6.Text

s1 = Replace(s1, "'", " ")
Text6.Text = s1

[/CODE]

It removes the single quote (') and adds an empty string (" ")Let's give that a whirl.

Text6.Text is your multiline textbox by the way.

Good luck!

thanks dear !!!

but its not working.

[vishwaskothari]

thanks dear !!!

but its not working.

is there anybody who can help me ?????

[creative1]

hi
I never experience problem like this. I think if you store data in variable variable and then use it to print on report. It might help.

[QVeen72]

Hi,

how are you passing the values of textbox from Form to the Label in the Datareport...?
this works perfect here :

[code=vb]
DataReport1.Sec tions(2).Contro ls("Label1").Ca ption = Me.Text1.Text
DataReport1.Ref resh
DataReport1.Sho w
[/code]

Regards
Veena

[vishwaskothari]

Hi,

how are u passing the values of textbox from Form to the Label in the Datareport...?
this works perfect here :

[code=vb]
DataReport1.Sec tions(2).Contro ls("Label1").Ca ption = Me.Text1.Text
DataReport1.Ref resh
DataReport1.Sho w
[/code]

Regards
Veena

i am doing exactly the same thing but its not working
here is my code



With DataReport1


Set .DataSource = rs
.DataMember = rs.DataMember

.Sections("Sect ion4").Controls ("lblName").Cap tion = "'" & Me.txtName.Text & "'"

End With


what can be the reason?

regards
vishwas

[QVeen72]

i am doing exactly the same thing but its not working
here is my code



With DataReport1


Set .DataSource = rs
.DataMember = rs.DataMember

.Sections("Sect ion4").Controls ("lblName").Cap tion = "'" & Me.txtName.Text & "'"

End With


what can be the reason?

regards
vishwas

Hi,

You need not Wrap the Text with Single Quotes:

[code=VB]
.Sections("Sect ion4").Controls ("lblName").Cap tion = Me.txtName.Text
.Refresh
.Show
[/code]

REgards
Veena

[jamesd0142]

try using the mid function to pick out the first and last characters and remove them.