Results 1 to 13 of 13
  1. #1
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Character Maps (Access 2000)

    I am trying to insert this symbol into Access

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Character Maps (Access 2000)

    Perhaps your problem is more widespread than just Access - see attached screenshot.

    Have you tried keeping Alt down and typing the code followed by + on the numeric key pad? That works for me in Access 2002 (I don't have 2000)
    Attached Images Attached Images
    • File Type: png x.png (1.6 KB, 0 views)

  3. #3
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Character Maps (Access 2000)

    I cannot enter the keycode and I just get a line if I try to paste the symbol in. I guess Access 2000 does not support keycodes

    Crap

    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Character Maps (Access 2000)

    Which serivce pack of Access 2000 are you using? Select Help | About... to see the version.
    Which version of Windows are you using (95, 98, ME, NT, 2000, XP)?

  5. #5
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Character Maps (Access 2000)

    I am using service pack on XP. I noticed my symbol does not have a keystoke combination. So I guess I will something else. I can enter other symbols though, I just have to use the keypad [img]/forums/images/smilies/smile.gif[/img]

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Character Maps (Access 2000)

    But which service pack of Access 2000 are you using (if any)? Do you have "plain" Access 2000, or SP-1, SP-2 or SP-3?

  7. #7
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Character Maps (Access 2000)

    oops i meant SP3, sorry

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Character Maps (Access 2000)

    Perhaps other Access 2000 users can comment on this. According to Microsoft, there were problems with non-ASCII Unicode characters in SP-1, but they have been solved in SP-2 (included in SP-3).

  9. #9
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Character Maps (Access 2000)

    Maybe I am doing someting wrong. In the Character Map, using the arial font, on the bottom left, it shows U+2665 I have tried to copy and paste the sumbol, but no luck, and not sure what else to try. I also have the Hex, Octal and Binary Value infront of me if that helps

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Character Maps (Access 2000)

    That's a unicode symbol, which you probably don't want. Pick a different font, and it should be standard ASCII, and you will see how to type that character.
    Wendell

  11. #11
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Character Maps (Access 2000)

    <P ID="edit" class=small>(Edited by MarkD on 09-Aug-03 18:03. Correction noted.)</P>Hint: Type "& #9829" (w/o the space or quotes) to display
    Attached Images Attached Images

  12. #12
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Character Maps (Access 2000)

    <P ID="edit" class=small>(Edited by MarkD on 10-Aug-03 07:04. Added additional note re A2K.)</P>I still haven't figured out why the Lounge style sheets refuse to render HTML character entities correctly. If you create a generic HTML file in a text editor, and open in IE, the characters are rendered correctly. For example, this table lists the HTML entity names and numerical codes for the 4 suits (with bogus space added after "&" symbol) which are not rendered properly:

    <table border=1><td>spades</td><td>hearts</td><td>clubs</td><td>diamonds</td><td>& spades;</td><td>& hearts;</td><td>& clubs;</td><td>& diams;</td><td>& 9824;</td><td>& 9829;</td><td>& 9827;</td><td>& 9830;</td><tr><td>[b]
    Attached Images Attached Images

  13. #13
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Character Maps (Access 2000)

    One more note on this important topic: At work tested code below on a form using Access 2000 SR-1 on archaic Windows 98 system. The Unicode text was displayed correctly using code like this:

    Private Sub Command1_Click()

    Me.Field1 = ChrW(9824) & ChrW(9829) & ChrW(9827) & ChrW(9830)

    End Sub

    (See attached image) But A2K SP-3 on WIN XP did not display Unicode characters correctly. So recommendation would be to test this on target system, and if necessary use Datasheet view, which consistently displayed characters correctly.

    HTH
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •