display & on a label 1

[case81]

i have a text string b & H Tournament i a text field in my database, when i try and display it on a label it come out as BH with the H underlined,would greatly appreciate any help with this,

thanks in advance guys,

 

[CCLINT]

Use a double & sign as in &&

 

[case81]

thanks will try that

 

[case81]

hmm no good tried with && same result, with &&& its displays B&H with the H still underlined. Any ideas guys? sorry to be wreackin your heads

 

[strongm]

Change the Label's UseMnemonic property to false

 

[CCLINT]

I failed to see that you were setting the caption based on a value from the Database.
However,

b && H

still must work - you have to make sure that after changing the field value in the db you move off the record and refresh the recordset object or DC in your application.

Usually you need to do this double && when setting a label's caption but when showing a database field value, using strongm suggestion is the better way - what user wants to enter && in a name field? - unless you are just keeping static label caption data like a selection list or section title then do a double && in that list so you do not have to worry about setting the property.

I do use a public proceedure for intiating a form when it loads and use the tag property of labels to identify if the label is used for database data - then a loop is done through all labels on a form to set certain properties a ones identified like this get the UseMnemonic property set to false. But that is my preference......