Dual Format Or Input Mask???

Aug 21, 2006

Hi,

I am creating a database where the serialID can be a number of different 'formats'. TBH, I don't know if this can even be done in the first place, but on the off chance that it can....:p

Firstly, i'm not sure whether to use Input Mask or Format...

But the serial may be '1234567AB', '12345678AB' or '12AB1234AB'.

Or to put another way

'7 numbers 2 letters',

'8 numbers 2 letters'

or '2 numbers, 2 letters, 4 numbers, 2 letters'

I have tried creating a mask such as '00LL0000LL' (can't remember exactly, had some '9's in there too some where...) but just keep hitting a brick wall, whereby it not satisfying all of the types.

Any help much appreciated, Ben

View Replies


ADVERTISEMENT

Input Mask / Format

May 19, 2005

Hiya everyone,
I'm try to do a database for items with part numbers.
& I want to be able to set the field to only accept data which has two letters at the begining, but any other characters after that (no fixed size).

ie.
part num1: pn047589sdf8m3
part num2: pn6583
part num3: pnfdgmj5973m
part num4: pn-fdgmj-5973m

Is this possible to do?

Cos all I can do at the moment, is to put a fixed number of characters.
ie. is the field size is 30characters
then I'd have to do this:
>LLCCCCCCCCCCCCCCCCCCCCCCCCCCCC

but this isn't good.

I just need something like:
>LL*

* mean any character for as many characters in length.

Adam
BIGmrC

View 2 Replies View Related

Input Mask Or Format Or Other - Currency

May 17, 2006

Hi All,

My Querie:
I have a relational database, that is basically made up of a few tables, I will
simplify for this to two.
TblFieldNames and TblFieldValues

Basically using a form you can fill in a field (TblFieldNames.FieldName) and it
is then appended to TblFieldValues.FieldValue.

On the form the properties of the input text box are changed according to the
record selected in TblFieldNames.
Ie. ListBox with FieldNames from TableFieldNames
ListBox_AfterUpdate sets properties of
TxtValue

The Issue:
I have a Field in TblFieldNames that has a setting of Currency.
(TblFieldNames.FieldType = "Currency")

I have changed the TxtValue.Format = "Currency"

It doesn't:
A. Allow entry as a currency, ie. $ sign and thousand seperators
B. Append the details to the TblFieldValues Table, which it is going across to
into a field that is set as Text (this can't change)

I have tried:
Changing format of input Txt box
Changing Input Mask for inptu Txt Box
"$###,###,###" but doesn't work for me....
"/$###,###,###"
"/$###,###,###!"

I want it to allow me to enter in the Value as a Currency and append the value as a currency

ie.
Key Press = 12345
Field Shows = $12,345
Appends this value as Text?

Key Press = 1234567890
Field Shows = $1,234,567,890

Etc

Any ideas?

View 1 Replies View Related

Custom Input Mask For Date Format

Nov 18, 2004

Hi, I would like to create a Custom input mask in access 2000 with the format dd/mm/yy can someone please help me?

View 1 Replies View Related

Table Column Format / Input Mask?

Nov 21, 2012

I have problem loading data from an excel file in to a table. I usually import the excel file in to a table via VBA script (because there are some changes I need to do before importing).It was working fine until this week when the data in a cell for a particular column in the excel file changed from being 3 letters to 4 letters. The column in the table is defined as text.

The data in this column usually looks like 001, 002, 003 etc but one of the cells in the excel file has data as P001.So now I get an error Runtime Error 3349 even though I have defined the column as text. When I change the data P001 to 004 similar to the other data, it works just fine. Is there a format or Input Mask I can set so that the data are correctly loaded in to the table?Or am I missing something?

View 7 Replies View Related

Input Mask /format For Unbound Textbox - Currency

Dec 7, 2007

How do I apply this - can't seem to get it right - just want to control user into putting whatever and two deciimals for pence.

99.99 input mask is halfway there - except I don't want to limit the pounds amount. putting 99999.99 makes entering 12.31 etc a little awkward.

Cheers

View 5 Replies View Related

Proper Case Format Using Input Mask Or Rule Validation?

Jun 29, 2014

Is there a Input Mask or Rule Validation that would automatically or require user to input data into Access field in a proper case format? Such as my text would be "My Text" when viewing the actual table? If so how would you do it when in Design View of Table.

View 1 Replies View Related

Input Mask

Apr 26, 2005

HOW DO I DO THE FOLLOWING:

I want to use input mask in my email field i.e the @ must be present but i must be allowed to input values or numbers before and after the @. This did not worked because i have fixed the values: ????@????
thanks

View 2 Replies View Related

Input Mask

May 2, 2005

Dear All,

Is there any way that I can use an input mask to enter serial numbers of softwares.....

the data will be like this...

ABC8F-CHJ68-FH76F-GHF87-67JH5

Thanks in advance


Thanks

View 1 Replies View Related

Input Mask Maybe

Sep 15, 2005

What I have is field called contract number, and its entered as 09-0011, which is ok.

Now I like it to show up in a different field as 090011. I guess my first question can this be done. Or even better how would I do it?

Now your question is. Why don't you put it in correctly the first time, and the answer is we want the number to have a dash.

Any suggestions

Never can be easy for me.

View 3 Replies View Related

Input Mask

Jan 31, 2005

let's say i have a field, in which i store and identity card number. This number may consist up to 7 digits (of which 3 are mandatory) plus 1 letter (mandatory) at the end. Thus a valid identity card number may be the following: 1234567M, 123M

Eventually, since the field must always contain a letter, i set the data type to Text with field size of 8 ... and i set the inout mask as follows:

9999000L (since the first 4 digits are mandatory). With this input mask, if i have an ID Number of 123M, i have to input it as 0000123M.

Although, I would like to have the leading zeros, is it possible that during data entry time, i would simply type 123M, and i will get the zeros automatically, after the field loses the focus, rather than having to type them myself ?

Thank You

View 13 Replies View Related

Input Mask

Oct 18, 2005

Trying to set an input mask to Capitalize the first letter of a surname but also to do this for ie MacDonald or O'Brian? How can i do this?

View 1 Replies View Related

Input Mask

Jul 19, 2006

When you add a new column you can select different data types such as text, memo, currency,...

When I pick currency and typ in 12345 in the column and press tab it automatically puts the € sign behind 12345.....

View 1 Replies View Related

Input Mask Help

Sep 2, 2007

I am trying to create an input mask for a name field. I have Spanish names with two last names separated by a hyphen, a comma after the two last names, a space, and then the First Name a space and the Middle Name. The First Last Name needs to be in all capitals like the example. Example: NARANJO-Ramirez, Jose Luis

Can someone please help me format this mask. One trick is that there aren't always middle names. Since all parts of the name are different lenghts for everybody, I need to have an optional number of characters for each of the four parts of the name.

Thanks for your help.

View 2 Replies View Related

Input Mask

Apr 11, 2005

I have a text box on a form that holds a grid reference, (2 letters and 6 numbers). I have set the box up with an input mask, (>LL000000;0;_). Is there a way that when the user clicks in the box that the cursor will go to the start of the box. At present it goes wherever they click in the box. If they dont notice then the machine starts beeping at them, most annoying!

View 1 Replies View Related

Input Mask HELP!!!!

May 2, 2005

I have created an input mask but it depends what type of currency is..

If Me![Currency Counter] = "1" Then
Me![Serial No].InputMask = "LL00 000000"
Else
If Me![Currency Counter] = "2" Then
Me![Serial No].InputMask = "LL-00000000-L"
endif
endif

The problem is that if for example the currency counter = 2 the serial must be
AA-11111111-A but it is saving AA1111111A and i dont want it to save it like this.

Any help pls...

View 2 Replies View Related

Input Mask

May 12, 2006

I have a text box that has an Input Mask setup. The box is format to be
##-### (00-000;0;). My problem is, when the user clicks in the box it does not start at the beginning, it starts where ever the user clicks inside the box. Is there way to for when you click inside the box it automatically starts at the beginning?

View 2 Replies View Related

Input Mask

May 12, 2006

I have a text box that has an Input Mask setup. The box is format to be
##-### (00-000;0. My problem is, when the user clicks in the box it does not start at the beginning, it starts where ever the user clicks inside the box. Is there way to for when you click inside the box it automatically starts at the beginning?

View 1 Replies View Related

Input Mask For Importing

Feb 25, 2005

I have a table that I copy into daily from a shared Excel spreadsheet. I am trying to minimize the amount of touching up the data needs. What input mask should I use so that a field with four numbers...1234 (for example) will be converted to a nine-digit number with leading zeros (000001234) when the data is imported. I would like the nine-digit number to be saved.

Also, is there a way to have a date field import the date only & ignore any text?

View 2 Replies View Related

Input Mask For Zip Codes

May 23, 2005

I am working on a membership database that only has members from Canada and the United States. In the zipcode field, is it better to have two seaparate fields or is there an input mask that can handle both US and Canadian zip codes.

Thanks in advance.
24t42

View 2 Replies View Related

Input Mask Password Help

Jan 31, 2006

how can i only allow numbers to be entered when i make the input mask password

View 1 Replies View Related

Input Mask Problem

Jan 2, 2008

I have a number field that has three groups of 3 numbers: 123 456 789 or 12 345 678 (8 numbers). When there are only 8 numbers I need to have the first group of number contain 2 numbers and the other two groups to have the other six numbers. If my input mask filled from the right it would solve my problem if the mask was 900 000 000 (filled from the right) but I can't seem to figure this out. Your help is greatly appreciated.

Tyler

View 4 Replies View Related

Multiple Input Mask

Feb 25, 2008

Hi,

Can anyone tell me how I can format my access tables with multiple input masks under one field?

In my table I have formatted my telephone numbers so that they read (xxx) xxx-xxxx which suits our predominantly UK based business telephone numbers, however we also have a lot of Irish numbers which follow a different configuration e.g. (xxxxx) xxxx-xxxx - how can I add this second input mask so that both formats are recognised within the same column/ field?

Many thanks
RHorton

View 2 Replies View Related

Input Mask For Mobile Nos

Mar 25, 2005

Hi,

I am newbie and i need some help how to make an input mask for mobile no, which begins 79 or 99.

Thanks a lot
Andrew

View 5 Replies View Related

Input Mask For Surname With '

Aug 24, 2005

Is it possible to set up an input mask for a form for a surname field so that names will show first letter of name as a capital (easy), as in Smith - but for names like O'Connor, show the first and second letters as capitals? (and, of course, allow the ' to be entered).
Thanks.

View 1 Replies View Related

Input Mask Under Various Conditions

Nov 30, 2005

Greetings,

I am a little stumped in logic again

What I am trying to do is the following

If the value is on field is say "OA" then I need an input code of LL0000 or LL00000 in the next field
If the value is say "OT" then I need an input code of LL etc

What is the best way of going about this.

The code is for stock locations in a warehouse.

~rbinder

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved