Microsoft Access Field Format ??? - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
Thread Tools Display Modes
Old 01-19-2006, 04:40 PM   #1 (permalink)
Junior Techie
Join Date: Jun 2005
Posts: 48
Send a message via Yahoo to j4mes_bond25
Question Microsoft Access Field Format ???

Friend of mine is working on making a Bank Database in Microsoft Access.

After trying different validation format, we failed to get exactly what we wanted.

We did the setting for "Account Number" as "AutoNumber" & set the format in the way, that every time the new record gets created, this "Account Number" keeps on increasing by one (which we did by having "New Values as Increment"). However, since account number we want needs to be at least 5 digit long, I wonder how do we go about doing so ???

Furthermore, in another table, we want to set some sort of format for "Credit/Debit Card" in the way, that it has to be 16 digit long with "space" after each of the 4 digit i.e. in the format "0000 0000 0000 0000" & we wish this to be "Auto Number" & New Values as "Random", however, when we tried we kept on getting "-" sign in front of some of these "Credit/Debit Card" number, once we start typing other details. Additionally, what we want is even if we type in say "1000100010001000", some sort of format/validation automatically changing it to "1000 1000 1000 1000" (i.e. space after 4 digits) & we also want validation, which means the digit should NOT go over 16 & should NOT be less than 16.

Can anyone help in getting what we want in both of these cases i.e. the "Account Number" & "Credit/Debit Card".
Nope, I\'m NOT God, but I\'m British (which is the next best thing) ;)
j4mes_bond25 is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 03:59 AM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2018, vBulletin Solutions, Inc.