Charlotte Foust
cfoust at infostatsystems.com
Tue Oct 31 10:13:08 CST 2006
Put it in the OnChange event and cancel the event if the length would exceed the set limit. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia Sent: Tuesday, October 31, 2006 6:45 AM To: accessd at databaseadvisors.com Subject: [AccessD] Re: Limit Text in Field Oh yea! I should change the wording on that to show as a field name, not a file - (GstrFileName) was the wrong choice. But it really is a field that I made as a memo but don't want them to type a book, but they need more than the 255 for a txt field. I tried the ' say your text field is text1, couldn't you put text1 = left(text1,500) & it didn't like that - it gives a runtime error about the BeforeUpdate can't save the record. Also, Does anyone have something that shows how many characters have been typed (it shows as they type)? Sorry confused everyone on that one. Virginia Also, aren't file names limited to about 280 characters? Bobby -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com