Lonnie Johnson
prodevmg at yahoo.com
Mon Feb 19 11:18:35 CST 2007
Susan, Did you find anything else about this? Actually I did not know the property existed. I have always used variables or the tag property to store this. I was going to start using it and an associate says there are also problems with checkbox booleans and comboxes. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: Susan Harkins <ssharkins at setel.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Sunday, February 18, 2007 6:12:37 PM Subject: [AccessD] Value verses OldValue I ran into something interesting with the following expression: If ctl.Value <> ctl.OldValue Then It appears that unless you've changed the value, ctl.Value is empty. If there's been no change, shouldn't Value and OldValue been the same? Why is Value empty? This is in a form's Before Update event, which might matter. Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ____________________________________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097