Add apostrophe symbol in an input box

[#1]

Hey i have created an input box and every time i add an apostrophe symbol in it, the macro window pops up. How can i add an apostrophe symbol ( ' ) in an input box?

[Anil_Babu_Samineni]

Confusing, Where you want to add ' I understand in input box. In that, where?

[tresesco]

In the Constraint tab, check if any constraint is enabled. Try enabling 'No Constraint' in the Input Constraint section.

[#4]

Anywhere inside an input box

[#5]

i have already enabled the "No constraint" dialog

[tamilarasu]

Hi Vikas,

What is the error message you are getting while enter the apostrophe symbol?

[jonathandienst]

That is not normal behaviour. You may have a on OnChange or OnInput trigger on the variable that is attempting to call a VBS macro script.

[#8]

I am actually writing back whatever is written in the input box into a SQL database with the help of a macro. So whenever someone inserts an apostrophe symbol in the input box the macro window is opened.

[Anil_Babu_Samineni]

Can you share the macro?

[hemanthaanichet]

Hi Vikas,

Use CHR(39) for apostrophe.In Qlikview CHR(39) is for apostrophe

Regards

Hemanth