Expression builder escape character?

[jaybee3]

I'm trying to set up a default value for a text box. It will be a file path that contains an ampersand.

Everytime the form is loaded the text box evaluates the ampersand and so it disappears.

C:\J&B changes to C:\JB and so the subsequent code doesn't run.

Is there a way to escape the ampersand, like using a \ in other languages?



Thanks in advance

 

[Norie]

What exactly is the expression?

Have you tried using Chr(38)?

 

[jaybee3]

Found the problem: When copying anything with an ampersand into the default value property, Access seemed to automatically evaluate it to the following:

Copied path:"H:\Q&C\Client\2013\Nov\"
Generated "expression": ="H:\Q" & "C\Client\2013\Nov\"

I first tried removing the '" ' and ' "' as per the original path, but it was having unexpected results, displaying the path as "H:\QC\Client\2013\Nov\"

Replaced the generated expression with: ="H:\Q" & Chr(38) & "C\Client\2013\Nov\" as per your suggestion and it works. Thanks

(On a side note, also then removed the '" & Chr(38) & "' and it now works as originally expected. Strange. but it works :S)