hasta mañana

[matrixknow]

When reading the subject you're reflex could be "this is spam" its a access question ..
I have a table with a few spanish words. I wondering how to write typical spanish character like ñ on mañana ?
1. how to write (copy pazte is perhaps the worste solution).
2. spanish is a latin language, can you find the related special characters in an ascii or unicode reference table ?
3. do you need to modify your access options to this specification.

 

[VRoscioli]

AS you can see from

http://www.goascii.com

, the ñ character has ANSI code 241. If you are on a PC, you can create this character by holding down the shift key and typing 0241 on the numeric keypad and then releasing the shift key. This can be done for any ASCII or ANSI character.


-V

 

[matrixknow]

I found the reference in the ansi table = ok
If I try to use the combination in an access table field he jumps from right to left and up an down, but the character is not appearing

 

[VRoscioli]

Be sure you have NumLock enabled.


-V

 

[traingamer]

It's the alt key, not the shift key.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[VRoscioli]

Er... wow... not sure how I managed to typo that TWICE haha. Yes, the alt key, not the shift key.

Thanks, Greg


-V

 

[Remou]

Depending on your keyboard layout, AltGr may suit:

http://en.wikipedia.org/wiki/AltGr_key

 

[TheAceMan1]

How are ya matrixknow . . .


In form view for the textboxes with spanish you can [blue]steal a key[blue] for your purposes. The following code in the [blue]On Key Press[/blue] event of the spanish textboxes of interest will substitute the proper character when you enter the [blue]tilde[/blue] character ([blue]Shift + ~[/blue]):

[blue]   If KeyAscii = 126 Then KeyAscii = 241[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884: