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

  • Thread starter Thread starter skc
  • Start date Start date
S

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
 
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
 
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.
==============================================
 
see inline
-----Original Message-----
Are you sure there are no spaces in the field in the
Click to expand...
database, check your

Yes- checked everything - no spaces!
field properties.

Do you have any default values for the fields set, such
Click to expand...
as " "

No
or

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

Yes - what does this mean?
 
Back
Top