473,692 Members | 2,359 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Forcing Zero in Social Security Number Field and Putting Cursor at Left for Data Entry

Problem:

Social Security number being used in a database. First problem is
that it will not permit numbers beginning in zero to be entered - it
sees it as a null or empty space from what I can tell.

Next, foreign students have & as the initial part of their SSN. How
to do this??

Finally, how do I force the cursor to the far left of the field so the
person doing data entry does not have to backspace to the beginning of
the data entry field?

Please be specific - not a sophisticated person making the program!

Thanks.
Nov 12 '05 #1
6 4814
Social Security Numbers are not numbers even though they say they are. They are
text because they can start with 0, start with & and US SSNs have two dashes. So
you need to go to your table and change the data type of your SSN field to text.
All your problems will go away!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om...
Problem:

Social Security number being used in a database. First problem is
that it will not permit numbers beginning in zero to be entered - it
sees it as a null or empty space from what I can tell.

Next, foreign students have & as the initial part of their SSN. How
to do this??

Finally, how do I force the cursor to the far left of the field so the
person doing data entry does not have to backspace to the beginning of
the data entry field?

Please be specific - not a sophisticated person making the program!

Thanks.

Nov 12 '05 #2
In article <ta************ *****@newsread3 .news.atl.earth link.net>,
sp**@nospam.spa m says...
Social Security Numbers are not numbers even though they say they are. They are
text because they can start with 0, start with & and US SSNs have two dashes. So
you need to go to your table and change the data type of your SSN field to text.
All your problems will go away!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om...
Problem:

Social Security number being used in a database. First problem is
that it will not permit numbers beginning in zero to be entered - it
sees it as a null or empty space from what I can tell.

Next, foreign students have & as the initial part of their SSN. How
to do this??

Finally, how do I force the cursor to the far left of the field so the
person doing data entry does not have to backspace to the beginning of
the data entry field?

Please be specific - not a sophisticated person making the program!

Thanks.


ARGH That is horrid! A number is not text simply bcasue it starts with
a zero... That is (IMHO) very poor programming. You are mixing the
storage of a value with the display there of. Look in the formatting of
the controls you use to input/display the SSN and you will see how to
handle SSNs that begin with one or more 0s without bastardizing your
data.
Nov 12 '05 #3
How do I do this? Where would I look if you do not want to tell me,
and what is it called? Thanks.

On Wed, 14 Apr 2004 06:33:14 GMT, Ima Lostsoul <me@myprovider. com>
wrote:
In article <ta************ *****@newsread3 .news.atl.earth link.net>,
sp**@nospam.sp am says...
Social Security Numbers are not numbers even though they say they are. They are
text because they can start with 0, start with & and US SSNs have two dashes. So
you need to go to your table and change the data type of your SSN field to text.
All your problems will go away!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om...
> Problem:
>
> Social Security number being used in a database. First problem is
> that it will not permit numbers beginning in zero to be entered - it
> sees it as a null or empty space from what I can tell.
>
> Next, foreign students have & as the initial part of their SSN. How
> to do this??
>
> Finally, how do I force the cursor to the far left of the field so the
> person doing data entry does not have to backspace to the beginning of
> the data entry field?
>
> Please be specific - not a sophisticated person making the program!
>
> Thanks.


ARGH That is horrid! A number is not text simply bcasue it starts with
a zero... That is (IMHO) very poor programming. You are mixing the
storage of a value with the display there of. Look in the formatting of
the controls you use to input/display the SSN and you will see how to
handle SSNs that begin with one or more 0s without bastardizing your
data.


Nov 12 '05 #4
<<A number is not text simply bcasue it starts with a zero>>

Can you give me one example of a number that starts with a zero?

Steve
PC Datasheet
"Ima Lostsoul" <me@myprovider. com> wrote in message
news:MP******** *************** *@netnews.comca st.net...
In article <ta************ *****@newsread3 .news.atl.earth link.net>,
sp**@nospam.spa m says...
Social Security Numbers are not numbers even though they say they are. They are text because they can start with 0, start with & and US SSNs have two dashes. So you need to go to your table and change the data type of your SSN field to text. All your problems will go away!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om...
Problem:

Social Security number being used in a database. First problem is
that it will not permit numbers beginning in zero to be entered - it
sees it as a null or empty space from what I can tell.

Next, foreign students have & as the initial part of their SSN. How
to do this??

Finally, how do I force the cursor to the far left of the field so the
person doing data entry does not have to backspace to the beginning of
the data entry field?

Please be specific - not a sophisticated person making the program!

Thanks.


ARGH That is horrid! A number is not text simply bcasue it starts with
a zero... That is (IMHO) very poor programming. You are mixing the
storage of a value with the display there of. Look in the formatting of
the controls you use to input/display the SSN and you will see how to
handle SSNs that begin with one or more 0s without bastardizing your
data.

Nov 12 '05 #5
Ima Lostsoul <me@myprovider. com> wrote in
news:MP******** *************** *@netnews.comca st.net:
In article
<ta************ *****@newsread3 .news.atl.earth link.net>,
sp**@nospam.spa m says...
Social Security Numbers are not numbers even though they say
they are. They are text because they can start with 0, start
with & and US SSNs have two dashes. So you need to go to your
table and change the data type of your SSN field to text.
All your problems will go away!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word
Applications
re******@pcdata sheet.com
www.pcdatasheet.com
<Sami> wrote in message
news:4q******** *************** *********@4ax.c om...
> Problem:
>
> Social Security number being used in a database. First
> problem is that it will not permit numbers beginning in
> zero to be entered - it sees it as a null or empty space
> from what I can tell.
>
> Next, foreign students have & as the initial part of their
> SSN. How to do this??
>
> Finally, how do I force the cursor to the far left of the
> field so the person doing data entry does not have to
> backspace to the beginning of the data entry field?
>
> Please be specific - not a sophisticated person making the
> program!
>
> Thanks.

ARGH That is horrid! A number is not text simply bcasue it
starts with a zero...

Good grief! a text is not a number just because it contains only
digits. I remember learning, oh about thirty years ago, that you
should us a numeric field if you are going to add, subtract,
multiply or divide the contents thereof, else use type text.

A numeric field may also be used as a key, but you can do it with
text fields as well.
There is no guarantee that future SSNs will contain only the
characters 0 through 9.
That is (IMHO) very poor programming. You are mixing the storage of a value with the display there
of. Look in the formatting of the controls you use to
input/display the SSN and you will see how to handle SSNs that
begin with one or more 0s without bastardizing your data.


Nov 12 '05 #6
CDB
And as the original poster said, he must, now, include "&" in some cases.
That could be misinterpreted as a type-declaration character in a numeric
field.

Clive

"Bob Quintal" <bq******@gener ation.net> wrote in message
news:82******** *************** *******@news.te ranews.com...
Ima Lostsoul <me@myprovider. com> wrote in
news:MP******** *************** *@netnews.comca st.net:
In article
<ta************ *****@newsread3 .news.atl.earth link.net>,
sp**@nospam.spa m says...
Social Security Numbers are not numbers even though they say
they are. They are text because they can start with 0, start
with & and US SSNs have two dashes. So you need to go to your
table and change the data type of your SSN field to text.
All your problems will go away!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word
Applications
re******@pcdata sheet.com
www.pcdatasheet.com
<Sami> wrote in message
news:4q******** *************** *********@4ax.c om...
> Problem:
>
> Social Security number being used in a database. First
> problem is that it will not permit numbers beginning in
> zero to be entered - it sees it as a null or empty space
> from what I can tell.
>
> Next, foreign students have & as the initial part of their
> SSN. How to do this??
>
> Finally, how do I force the cursor to the far left of the
> field so the person doing data entry does not have to
> backspace to the beginning of the data entry field?
>
> Please be specific - not a sophisticated person making the
> program!
>
> Thanks.

ARGH That is horrid! A number is not text simply bcasue it
starts with a zero...

Good grief! a text is not a number just because it contains only
digits. I remember learning, oh about thirty years ago, that you
should us a numeric field if you are going to add, subtract,
multiply or divide the contents thereof, else use type text.

A numeric field may also be used as a key, but you can do it with
text fields as well.
There is no guarantee that future SSNs will contain only the
characters 0 through 9.
That is (IMHO) very poor programming.
You are mixing the storage of a value with the display there
of. Look in the formatting of the controls you use to
input/display the SSN and you will see how to handle SSNs that
begin with one or more 0s without bastardizing your data.

Nov 12 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

116
7501
by: Mike MacSween | last post by:
S**t for brains strikes again! Why did I do that? When I met the clients and at some point they vaguely asked whether eventually would it be possible to have some people who could read the data and some who couldn't but that it wasn't important right now. And I said, 'sure, we can do that later'. So now I've developed an app without any thought to security and am trying to apply it afterwards. Doh!, doh! and triple doh!
1
1387
by: Sami | last post by:
Title says it all. Using a Listbox to look up numbers - ie SSN for a student - and then all of a sudden it shows up as 2323E+08 instead of say 232-23-2323. Help! Also, how can I force zeroes to appear in a key number? This is necessary for use with IDs beginning with a zero. Finally, input forced to begin in far left of field? There is a character used, and for the life of me I cannot recall.
6
263
by: Sami | last post by:
Problem: Social Security number being used in a database. First problem is that it will not permit numbers beginning in zero to be entered - it sees it as a null or empty space from what I can tell. Next, foreign students have & as the initial part of their SSN. How to do this?? Finally, how do I force the cursor to the far left of the field so the
258
8616
by: Terry Andersen | last post by:
If I have: struct one_{ unsigned int one_1; unsigned short one_2; unsigned short one_3; }; struct two_{ unsigned int two_1;
4
2017
by: tony | last post by:
I'm designing a survey form page that will be fairly complex and am becoming confident enough with PHP now to tackle most things. (Thanks to everyone here who has helped) Before I go too far with this I was wondering if anyone could perhaps offer advice or point me to any documents/web pages that could help with ensuring the security of the form/page and site. It is likely that the form will come under attack I expect. Even comments...
1
1595
by: ricky.fung | last post by:
I have several VBA functions in my Access Database that do not work. I have a combobox that filters my subform data however I cannot select anything when logged in with Read Only permission. The statusbar comes up with a message saying: "Recordset is not updatable" This combobox works with Admin permissions but not Read Only.
8
4003
by: King | last post by:
Hi I have following MS Acess query Here is the query ID Name Prgm ID Client ID Date Start Time End Time Minutes C4 Trisha TIP DEK0703 7 /7 /2006 10:00:00 AM 12:00:00 PM 120
3
4600
by: Klaus Brune | last post by:
Hello all, When one tabs through a form (specifically, in Firefox), all the text in a field is automatically selected. What I'm looking for is a way to put a function (in onFocus perhaps) that will automatically move to the END of the existing text (a blinking cursor). Yes, I've Googled, but cannot seem to locate just what I'm looking for.
0
8610
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8545
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9090
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8810
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8810
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5822
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4327
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2978
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2242
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.