[AccessD] Access 2007/Vista weirdness

Doug,
Len() only applies to string.  just remove it.  ShipQty.SelLength =
Me!shipQty
Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Thursday, February 14, 2008 2:43 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access 2007/Vista weirdness

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com