[AccessD] Set max no of chars in a textfield

Personally I use something like:

If Len(Me!NewNote) > 254 Then GoTo BigNote
BigNote:
    MsgBox "The note cannot be over 255 characters.  Your Note is " & 
Len(Me!NewNote) & ".  Please Shorten the note or make a seperate Entry."

Mark

>From: "Gustav Brock" <Gustav at cactus.dk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Set max no of chars in a textfield
>Date: Fri, 05 Jan 2007 13:49:53 +0100
>
>Hi Sander
>
>I wouldn't say that. Just type in 250 chars of C ...
>You just need to do it once for each field.
>
>/gustav
>
> >>> accessd666 at yahoo.com 05-01-2007 13:36 >>>
>Ok, so there isn't a way to do this without programming. Too bad.
>Throughout the application there is a lot of formatting that is entered 
>into the properties. I wanted to maintain this way of working...
>
>Thnx everybody
>
>----- Original Message ----
>From: Gustav Brock <Gustav at cactus.dk>
>To: accessd at databaseadvisors.com
>Sent: Friday, January 5, 2007 12:10:39 PM
>Subject: Re: [AccessD] Set max no of chars in a textfield
>
>Hi Sander
>
>The C will do:
>
>   Me!txtInput.InputMask= String(250, "C")
>
>/gustav
>
> >>> accessd666 at yahoo.com 05-01-2007 11:57 >>>
>It isn't bound...
>
>Sander
>
>----- Original Message ----
>From: Gustav Brock <Gustav at cactus.dk>
>To: accessd at databaseadvisors.com
>Sent: Friday, January 5, 2007 11:29:07 AM
>Subject: Re: [AccessD] Set max no of chars in a textfield
>
>Hi Sander
>
>If the textbox is bound to a table field with a max. text size of 250, that 
>should happen automatically.
>
>/gustav
>
> >>> accessd666 at yahoo.com 05-01-2007 08:55 >>>
>Hi group,
>
>I need to set an input mask for a textfield. The textfield is 250 long.
>Is it possible to set a range e.g.:
>Input mask: C(250)
>
>This should mean a user can enter every char for a max length of 250.
>
>Hope this makes sence.
>
>Regards,
>
>Sander
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Communicate instantly! Use your Hotmail address to sign into Windows Live 
Messenger now. http://get.live.com/messenger/overview