Form Field Display

[Eric H.]

I've developed a database using the switchboard for menus. At the top, I
inserted a field that displays the "Item Text" to let the user know which
menu they were on. However, because I have to display a shortcut key on each
menu item, I have to insert an ampersand (&) character before each shortcut
key for display purposes. The ampersand now displays along with the text at
the top. Is there a way to omit, or hide, the ampersand when it displays in
form view?

 

[bhicks11 via AccessMonster.com]

You could do somthing like this:

mystring = left(me.Itemtext,instr("&")-1) & mid(me.ItemText,instr("&")+1,10)

Of course you need to play with the verbage to match your database.

Bonnie
http://www.dataplus-svc.com