Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Access 2000 help
From:	DebbieG <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Tue, 5 Mar 2002 13:09:49 -0600
Content-Type:	text/plain
Parts/Attachments:	text/plain (26 lines)

I'm designing a database.  I think I'm brain-dead because I should be able
to figure this out.

I have a zipcode field with an input mask (00000-9999).  When I use this on
a report and the last 4 numbers are blank the dash (-) still prints.  And if
I use this on envelopes the barcode fails because of the dash.

Does anyone know of a simple way to eliminate the dash if the last 4 numbers
are blank?
Or how can I fill the last 4 positions with zeros if the user doesn't input
them?
I would like to be able to do this at the table or query level because I'm
exporting it to Word for the envelopes.  Unless someone knows of a way to
print envelopes in Access.

Like I said, I'm at the point with this that I can't even think of the
simplest thing.

Thanks in advance for any help.

Debbie Grabb

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG