Missing 'hash' key?

  • Thread starter Thread starter Jason O
  • Start date Start date
J

Jason O

I've just installed Access at home and have realised my keyboard doesn't
have a 'hash' key - the No. sign, or noughts & crosses grid (in case 'hash'
isn't a universal name for it).

_|_|_
_|_|_
| |

I've tried simulating it above. Anyway, as you can appreciate, I need it for
access, so wondered if anyone knew any key combinations that would give me
it.

Any healp greatly appreciated.

TIA

Jason
 
Add "octothorpe" to your list of names for the symbol.
http://www.sigtel.com/tel_tech_octothorpe.html <g>

On all of the keyboards I just checked in my house, it's above the 3 key.
What kind of keyboard do you have (where are you located, because keyboards
can be regional)? Go into Regional and Language Options through the control
panel, look on the Languages tab, and click the Details button. What's
specified for Keyboard?

Unfortunately, there's no key combination that I'm aware of to produce that
symbol.

One possibility within Access is to create an AutoKeys macro that lets you
map some uncommon combination of keys (say, Ctrl-Shift-H, for Hash) to use
SendKeys to produce that symbol. To do this, create a new macro. Under Macro
Name, put +^h, and for Action select SendKeys. In the Keystrokes box, put #.
(Yes, I know you don't have a # key, so that could be a problem! Open the
Immediate Window, using Ctrl-G and type ?Chr(35) then hit Enter. You'll get
a # symbol that you can copy and paste into the box in the Macro). Save the
macro, naming it AutoKeys. Now, anytime you use that combination of
Ctrl-Shift-H, you'll get #.
 
I can get it on my keyboard by having num lock on and pressing ALT-3-5
(using the numeric keypad for the 3 and 5)
 
Add "octothorpe" to your list of names for the symbol.
http://www.sigtel.com/tel_tech_octothorpe.html <g>

On all of the keyboards I just checked in my house, it's above the 3 key.
What kind of keyboard do you have (where are you located, because keyboards
can be regional)? Go into Regional and Language Options through the control
panel, look on the Languages tab, and click the Details button. What's
specified for Keyboard?

Unfortunately, there's no key combination that I'm aware of to produce that
symbol.
Click to expand...

Alt 035 produced this # on my keyboard.
 
Sometimes called the "Pound Key".

In code you can use Chr(35), however, you are really going to want a new
keyboard.
If you have some higher power (wife, mother, etc) denying such a request, a
cup of coffe, a beer, etc, spilled in a keyboard will render it totally
useless :)
 
Back
Top