Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Avoiding Blanks

Status
Not open for further replies.

mlocurci

MIS
Oct 17, 2001
210
US
I have this code:

Request.form("dayOff1")& vbcrlf&_
Request.form("dayOff2")& vbcrlf&_
Request.form("dayOff3")& vbcrlf&_
Request.form("dayOff4")& vbcrlf&_
Request.form("dayOff5")& vbcrlf&_
Request.form("dayOff6")& vbcrlf&_
Request.form("dayOff7")& vbcrlf&_
Request.form("dayOff8")& vbcrlf&_
Request.form("dayOff9")& vbcrlf&_
Request.form("dayOff10")& vbcrlf&_
vbcrlf&_

My output to an email i create, looks like this:

1/1/02
<field is blank>
1/1/02

How can i eliminate the extra space??
 
if not isnull(Request.form(&quot;dayOff1&quot;)) then
Request.form(&quot;dayOff1&quot;)& vbcrlf
end if

and so one and so forth...

damn i hate shooting blanks Bastien

There are many ways to skin this cat,
but it still tastes like chicken
 
Unfortunately, request.form will never be null...
Try this:

IF TRIM(request.form(&quot;dayOff1&quot;)) <> &quot;&quot; THEN ....


Or this:

IF isDate(request.form(&quot;dayOff1&quot;)) THEN .... -- What did you expect? This is FREE advice. LOL[ponder]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top