<%Trim(<FP_FieldVal...>) - unwanted spaces

[skc]

I am trying to use a FP2000 DRW to post items into a
form. The form will be saved to a database, so I am not
using the DRW around the form, but fire the DRW at the
beginning of the form.

The form contains <%=<database field%> for all text-box
and scrolling-textbox fields. The DRW contains <%
<database field>=FP_FieldVal(fp_rs,"databasefield")%>

What I am experiencing are spaced " " at the beginning of
the text box and scrolling text-box fields using this. I
checked my Access2000 database, and the fields are indeed
blank, but somehow I am getting spaces.

I used the <%=Trim(<database field>)%> i.e. Trim command,
in my text-box and scrolling tex-box fields but this has
not proved to be successfull.

Please can someone help me get rid of these spaces!!!!

skc

 

[Bob Lehmann]

The space is probably in the value attribute then...
value=" <%=database field%>"
<textarea> <%=<database field%></textarea>

You could do a view source to check this.

Bob Lehmann

 

[skc]

no...can't see any spaces

 

[Thomas A. Rowe]

Are you sure there are no spaces in the field in the database, check your
field properties.

Do you have any default values for the fields set, such as " "

or

Do you have the fields set to not Allow Zero Length?
--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Bob Lehmann]

URL?

Bob Lehmann

no...can't see any spaces

 

[skc]

see inline

-----Original Message-----
Are you sure there are no spaces in the field in the

database, check your

Yes- checked everything - no spaces!

field properties.

Do you have any default values for the fields set, such

as " "

No

or

Do you have the fields set to not Allow Zero Length?

Yes - what does this mean?