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

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
 
B

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
 
T

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top