[libreoffice-users] Re: Base - creating an input mask for a postcode, telephone number, email address

Am 09.09.2012 21:17, naomi.brown@gmail.com wrote:
> Hi,
>
> I'm very new to Base, so any help is appreciated! I've created the fields
> postcode and email address, amongst others, and I want to create an input
> mask for each of them.
>
> I've started with the postcode mask, and entered AANNNAA and I've tried
> LLNNNLL in the field properties box but neither of them seem to work, the
> only things that are rejected are those that are over 7 characters.
>
> Is it possible to stop Base from removing the first 0 in a number field?

Phone numbers, post codes, mail addresses are text values and should be 
stored in VARCHAR fields.


> Also, I think I should be using a list box or combo box to limit my user to
> predefined values, but I have no idea how to do that. For example, I would
> like them to have to choose from: Miss, Mrs, Mr for their title.


List boxes are made for this. Combo boxes are the same as text fields 
with additional auto-complete functionaility.
You get more qualified help on http://user.services.openoffice.org where 
you find forums to ask Base related questions, a tutorial section and 
example documents.
For instance: [Solved] Phone number format
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=10132




--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted