[AccessD] Access 2007/Vista weirdness

Hi Doug

As Stuart mentions, you probably assumes to much. Try to be more explicit:

Private Sub ShipQty_GotFocus()
  Dim txt As TextBox
  Set txt = Me!ShipQty
  txt.SelLength = Len(txt.Text)
  Set txt = Nothing
End Sub

If that works you may be able to reduce it to:

Private Sub ShipQty_GotFocus()
  With Me!ShipQty
    .SelLength = Len(.Text)
  End With
End Sub

/gustav

>>> dbdoug at gmail.com 14-02-2008 03:43 >>>
Hello All:

I have a client who is getting the error 'The setting you entered isn't
valid for this property' on the following code:

Private Sub ShipQty_GotFocus()
  ShipQty.SelLength = Len(ShipQty)
End Sub

ShipQty is a bound textbox; the bound field is numeric and is never null.

This happens on two different machines with Windows Vista/Office 2007
running a db in Access 2007 format.  His other machines running Windows XP,
Access 2003 and the same database in Access 2003 format have no problem.  I
have not been able to reproduce the problem in Access 2007 running under
Windows XP.

Any comments would be appreciated...

Doug Steele