[AccessD] Limit Text in Field

http://www.lebans.com/limittextinput.htm

William Hindman

----- Original Message ----- 
From: "Hollis, Virginia" <hollisvj at pgdp.usec.com>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, October 31, 2006 9:45 AM
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
>