For some reason, the tilde key (default key for most consoles) just isn't recognized with Apple keyboards under Windows. I can't figure out why, and everything I've tried hasn't worked.
I use an Apple wireless keyboard with my Mac Pro, and of course the tilde key isn't recognized at all. So, any time I'm playing Skyrim and want to open the console, I've got to hook up an old (non-Apple) USB keyboard and push the tilde key, which of course works.
I really hope that someone here on the forums can chime in and offer some useful advice! It'd be nice to not have to plug in another keyboard any time I want to use the tilde key.
Sorry this isn't very helpful, but you're definitely not the only one with this issue!
Good Luck! 🙄