I have removed the .Value, but I still receive the same error.

Nope. I thought that Steve may send us a really easy question worth 100 points, but then I woke up at my desk ;).

Whoops! Don't worry though, when I answered it the first time last month I got it wrong, and then the answers...

Well thats what happened, the QOTD for today is in fact this one :hehe:.

If only lay about workers were this easy to CONVERT 😎 :

IF NOT COMMITTED

SETUSER TO COMPUTE AND

KILL IDENTITY

smunson (8/11/2008)

---

As for what to do about the space problem, I think you'll have no choice but to make that the first thing you check for on the KeyDown event,...

Ok, I have it working now for the subform/main form. I have two problems which I will separate below, as it has turned out to be quite lengthy, which...

Once again, thanks Steve, with your code and some modifications, I think I may have done it :D. I haven't fully tested it, as it getting a little late...

Oh right, sorry, I misread your post. So I wouldn't be able to do something like I said then as no event is fired? Thats rather annoying!

smunson (8/8/2008)

---

I've just done some testing, and it turns out you CAN know where the cursor is. You use the SelStart property for that. However, the...

smunson (8/8/2008)

---

Just curious, but I take it that merely setting the other control to equal the value of the textbox that's being typed into, as part of the keypress event,...

Can anyone help me with this, im still having trouble.

Thanks.

Got it right :cool:. Out of interest, what was the "@b bigint" for, to try and confuse people with the @b-17 answer :D?

I wonder what will happen when August 15th comes around :D.

Shaun McGuile (7/15/2008)

---

Grant Fritchey (7/15/2008)

---

Well it sure doesn't work by default. I tried it in 2005 and 2008 and received nothing. I also note, that the answer, ALT-F1, is not...