Need help with zip code issue on lables

I'm using MS Access; Is there an easy way to add a "0" in front of my zip codes? I am printing address lables and the "0" is not showing up? Help!

Oct 10 '07 #1

Subscribe Post Reply

1330

epots9

1,351

Expert 1GB

make the datatype varchar instead of number

Oct 10 '07 #2

debasisdas

8,127

Expert 4TB

or else simply concadinate a 0 in front of the zipcode.

Oct 11 '07 #3

pbmods

5,821

Expert 4TB

Moving to the Access forum....

Oct 11 '07 #4

missinglinq

3,532

Expert 2GB

Or, keeping the ZipCode as a numeric datatype, use formatting, i.e Format(MyZipCode, "00000")

When defining the datatype for a field that contains digits only, this test should be applied:

Will the field ever be used for mathematical calculations or for comparative purposes ?

If the answer is YES, then use a numerical datatype.

Examples: quantities, ratings

If the answer is NO, then use a text datatype.

Examples: Zip Codes, ID Numbers, telephone numbers

Welcome to TheScripts!

Linq ;0)>

Oct 11 '07 #5

Similar topics

Need a hand

by: Justin Lazanowski | last post by:

I have a form that programmatticly creates 5 labels. Then programatticly should dispose them, when this happens when it gets down to two lables left it says that I get a null ref exception.. and I...

C# / C Sharp

Is there a way to reuse dynamic controls with multiple parents?

by: Homam | last post by:

So I have a composite paging control that shoulld be positioned on the page like this: PagNav ResultSetDisplay PagNav I know that I can't resuse the PagNav more than once in the form, so I...

ASP.NET

Need to display column name on detail section of a crystal report.

by: Meena | last post by:

Hi Every Body, I have created a crystal Report and linked to my vb.net forms and working fine, I added more drill drowns in groups everything fine, but What I need is I am not able to display...

Visual Basic .NET

how can create lables control array in mobile web application in vb.net ?

by: nehal | last post by:

Sir, i want in my application, a form should display lables according to the data in the database means no. of lables are not decided. how can i do this ? i also want my first form should...

Visual Basic .NET

Need Advice - Calendar Outlook style

by: =?Utf-8?B?R2lkaQ==?= | last post by:

Hi, I'm trying to build a Calendar (outlook style) with C#. When I just thought i almost finished, i found out that I've few problems. I want my calndar will have the ability to show few...

C# / C Sharp

C# GroupBox visibility issue

by: sudhivns | last post by:

Hi, I have added few lables into Groupbox control. Groupbox and all lable visible property set to true in UI. But at runtime, all these lables are not visible. While debugging found that...

.NET Framework

Any Good software for gett in lables print with master detail records ?

by: Shalini Bhalla | last post by:

i want to generate lables on which records are coming from diff tables , in form of master -- detail relation ship , can you suggest me a good lable printing software which can help me in this...

General

Data Entery Webpage with tables

by: Peter | last post by:

I have the following web page and I am trying to have the Field lables NOT to wrap. It looks fine in a designer but when I run the program in a browser the lables that have a space wrap. How do I...

ASP.NET

Problem in ASP.NET with Visual Web Developer

by: greenMark | last post by:

I recently moved to Visual web developer 2008 and it seems I can't move the GUI controls(Text box,lables etc) where I want them. when i drag the control,example the button,to my page,it display on...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General