This has always bugged me. If you create a textbox with an initial value
which is a field value, like <% = FP_FieldVal (fp_rs, "FirstName")%> then
when the form is live and you click in the text box when it's empty (there
was no field value in the db) the cursor is on the second character. If the
user doesn't manually backspace to the first character it loads a value into
the database with a <space> first character. That can screw up sorting
something fierce. It's not a problem when there is no initial field value
coded into the text box or if you tab into the textbox. Try it.
Is there any kind of workaround?

There should not be a space there unless you either set a space a a defaut value in your Db or your html has the space in it

Make sure the code looks like (on 1 line)
<textarea rows="2" cols="20"><%=FP_FieldVal (fp_rs, "FirstName")%></textarea>


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"Steve Spicer" <(E-Mail Removed)> wrote in message news:560FDDEA-1162-433D-A950-(E-Mail Removed)...
| This has always bugged me. If you create a textbox with an initial value
| which is a field value, like <% = FP_FieldVal (fp_rs, "FirstName")%> then
| when the form is live and you click in the text box when it's empty (there
| was no field value in the db) the cursor is on the second character. If the
| user doesn't manually backspace to the first character it loads a value into
| the database with a <space> first character. That can screw up sorting
| something fierce. It's not a problem when there is no initial field value
| coded into the text box or if you tab into the textbox. Try it.
| Is there any kind of workaround?

to be sure you could trim the value
<textarea rows="2" cols="20"><%=trim(FP_FieldVal (fp_rs,
"FirstName"))%></textarea>

--
Cheers,
Jon
Microsoft MVP

"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> There should not be a space there unless you either set a space a a defaut
> value in your Db or your html has the space in it
>
> Make sure the code looks like (on 1 line)
> <textarea rows="2" cols="20"><%=FP_FieldVal (fp_rs,
> "FirstName")%></textarea>
>
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "Steve Spicer" <(E-Mail Removed)> wrote in message
> news:560FDDEA-1162-433D-A950-(E-Mail Removed)...
> | This has always bugged me. If you create a textbox with an initial value
> | which is a field value, like <% = FP_FieldVal (fp_rs, "FirstName")%>
> then
> | when the form is live and you click in the text box when it's empty
> (there
> | was no field value in the db) the cursor is on the second character. If
> the
> | user doesn't manually backspace to the first character it loads a value
> into
> | the database with a <space> first character. That can screw up sorting
> | something fierce. It's not a problem when there is no initial field
> value
> | coded into the text box or if you tab into the textbox. Try it.
> | Is there any kind of workaround?
>
>

That doesn't work either. You can go to
http://www.spicerweb.org/tesadd.asp
to see what I mean. You will need to click on the hyperlink in the results
to take you to the edit page where you can click in the empty last name
textbox.
The cursor will be on the second character.

"Jon Spivey" wrote:

> to be sure you could trim the value
> <textarea rows="2" cols="20"><%=trim(FP_FieldVal (fp_rs,
> "FirstName"))%></textarea>
>
> --
> Cheers,
> Jon
> Microsoft MVP
>
> "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > There should not be a space there unless you either set a space a a defaut
> > value in your Db or your html has the space in it
> >
> > Make sure the code looks like (on 1 line)
> > <textarea rows="2" cols="20"><%=FP_FieldVal (fp_rs,
> > "FirstName")%></textarea>
> >
> >
> > --
> >
> > _____________________________________________
> > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> > "Warning - Using the F1 Key will not break anything!" (-;
> > To find the best Newsgroup for FrontPage support see:
> > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> > _____________________________________________
> >
> >
> > "Steve Spicer" <(E-Mail Removed)> wrote in message
> > news:560FDDEA-1162-433D-A950-(E-Mail Removed)...
> > | This has always bugged me. If you create a textbox with an initial value
> > | which is a field value, like <% = FP_FieldVal (fp_rs, "FirstName")%>
> > then
> > | when the form is live and you click in the text box when it's empty
> > (there
> > | was no field value in the db) the cursor is on the second character. If
> > the
> > | user doesn't manually backspace to the first character it loads a value
> > into
> > | the database with a <space> first character. That can screw up sorting
> > | something fierce. It's not a problem when there is no initial field
> > value
> > | coded into the text box or if you tab into the textbox. Try it.
> > | Is there any kind of workaround?
> >
> >
>
>
>

Post a code snipped of your form at the top of http://www.spicerweb.org/tesadd.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"Steve Spicer" <(E-Mail Removed)> wrote in message news:06A29BC5-B397-413B-8F48-(E-Mail Removed)...
| That doesn't work either. You can go to
| http://www.spicerweb.org/tesadd.asp
| to see what I mean. You will need to click on the hyperlink in the results
| to take you to the edit page where you can click in the empty last name
| textbox.
| The cursor will be on the second character.
|
| "Jon Spivey" wrote:
|
| > to be sure you could trim the value
| > <textarea rows="2" cols="20"><%=trim(FP_FieldVal (fp_rs,
| > "FirstName"))%></textarea>
| >
| > --
| > Cheers,
| > Jon
| > Microsoft MVP
| >
| > "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
| > news:%(E-Mail Removed)...
| > > There should not be a space there unless you either set a space a a defaut
| > > value in your Db or your html has the space in it
| > >
| > > Make sure the code looks like (on 1 line)
| > > <textarea rows="2" cols="20"><%=FP_FieldVal (fp_rs,
| > > "FirstName")%></textarea>
| > >
| > >
| > > --
| > >
| > > _____________________________________________
| > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > > "Warning - Using the F1 Key will not break anything!" (-;
| > > To find the best Newsgroup for FrontPage support see:
| > > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
| > > _____________________________________________
| > >
| > >
| > > "Steve Spicer" <(E-Mail Removed)> wrote in message
| > > news:560FDDEA-1162-433D-A950-(E-Mail Removed)...
| > > | This has always bugged me. If you create a textbox with an initial value
| > > | which is a field value, like <% = FP_FieldVal (fp_rs, "FirstName")%>
| > > then
| > > | when the form is live and you click in the text box when it's empty
| > > (there
| > > | was no field value in the db) the cursor is on the second character. If
| > > the
| > > | user doesn't manually backspace to the first character it loads a value
| > > into
| > > | the database with a <space> first character. That can screw up sorting
| > > | something fierce. It's not a problem when there is no initial field
| > > value
| > > | coded into the text box or if you tab into the textbox. Try it.
| > > | Is there any kind of workaround?
| > >
| > >
| >
| >
| >

I've posted code at http://www.spicerweb.org/tesadd.asp for that page and for
the editestdb.asp page that the hyperlink takes you to. That page is the
first step in an edit database page which is not completed for this test. The
whole routine for pages to editing the database I created several years ago
for a work "rolodex" and it's bugged me since then that the cursor would be
placed on the second character.
The tutorial for creating the edit pages is at
http://spicerweb.org/tutorial/tutorial/tutorial.htm

"Stefan B Rusynko" wrote:

> Post a code snipped of your form at the top of http://www.spicerweb.org/tesadd.asp
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "Steve Spicer" <(E-Mail Removed)> wrote in message news:06A29BC5-B397-413B-8F48-(E-Mail Removed)...
> | That doesn't work either. You can go to
> | http://www.spicerweb.org/tesadd.asp
> | to see what I mean. You will need to click on the hyperlink in the results
> | to take you to the edit page where you can click in the empty last name
> | textbox.
> | The cursor will be on the second character.
> |
> | "Jon Spivey" wrote:
> |
> | > to be sure you could trim the value
> | > <textarea rows="2" cols="20"><%=trim(FP_FieldVal (fp_rs,
> | > "FirstName"))%></textarea>
> | >
> | > --
> | > Cheers,
> | > Jon
> | > Microsoft MVP
> | >
> | > "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> | > news:%(E-Mail Removed)...
> | > > There should not be a space there unless you either set a space a a defaut
> | > > value in your Db or your html has the space in it
> | > >
> | > > Make sure the code looks like (on 1 line)
> | > > <textarea rows="2" cols="20"><%=FP_FieldVal (fp_rs,
> | > > "FirstName")%></textarea>
> | > >
> | > >
> | > > --
> | > >
> | > > _____________________________________________
> | > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> | > > "Warning - Using the F1 Key will not break anything!" (-;
> | > > To find the best Newsgroup for FrontPage support see:
> | > > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> | > > _____________________________________________
> | > >
> | > >
> | > > "Steve Spicer" <(E-Mail Removed)> wrote in message
> | > > news:560FDDEA-1162-433D-A950-(E-Mail Removed)...
> | > > | This has always bugged me. If you create a textbox with an initial value
> | > > | which is a field value, like <% = FP_FieldVal (fp_rs, "FirstName")%>
> | > > then
> | > > | when the form is live and you click in the text box when it's empty
> | > > (there
> | > > | was no field value in the db) the cursor is on the second character. If
> | > > the
> | > > | user doesn't manually backspace to the first character it loads a value
> | > > into
> | > > | the database with a <space> first character. That can screw up sorting
> | > > | something fierce. It's not a problem when there is no initial field
> | > > value
> | > > | coded into the text box or if you tab into the textbox. Try it.
> | > > | Is there any kind of workaround?
> | > >
> | > >
> | >
> | >
> | >
>
>
>

You have a space in the value -
<input type="text" name="T2" size="35" value="&nbsp;">Bob Lehmann"Steve
Spicer" <(E-Mail Removed)> wrote in message
news:BF853B43-C9AF-4049-BFD8-(E-Mail Removed)...
> I've posted code at http://www.spicerweb.org/tesadd.asp for that page and
for
> the editestdb.asp page that the hyperlink takes you to. That page is the
> first step in an edit database page which is not completed for this test.
The
> whole routine for pages to editing the database I created several years
ago
> for a work "rolodex" and it's bugged me since then that the cursor would
be
> placed on the second character.
> The tutorial for creating the edit pages is at
> http://spicerweb.org/tutorial/tutorial/tutorial.htm
>
> "Stefan B Rusynko" wrote:
>
> > Post a code snipped of your form at the top of
http://www.spicerweb.org/tesadd.asp
> >
> > --
> >
> > _____________________________________________
> > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> > "Warning - Using the F1 Key will not break anything!" (-;
> > To find the best Newsgroup for FrontPage support see:
> > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> > _____________________________________________
> >
> >
> > "Steve Spicer" <(E-Mail Removed)> wrote in message
news:06A29BC5-B397-413B-8F48-(E-Mail Removed)...
> > | That doesn't work either. You can go to
> > | http://www.spicerweb.org/tesadd.asp
> > | to see what I mean. You will need to click on the hyperlink in the
results
> > | to take you to the edit page where you can click in the empty last
name
> > | textbox.
> > | The cursor will be on the second character.
> > |
> > | "Jon Spivey" wrote:
> > |
> > | > to be sure you could trim the value
> > | > <textarea rows="2" cols="20"><%=trim(FP_FieldVal (fp_rs,
> > | > "FirstName"))%></textarea>
> > | >
> > | > --
> > | > Cheers,
> > | > Jon
> > | > Microsoft MVP
> > | >
> > | > "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> > | > news:%(E-Mail Removed)...
> > | > > There should not be a space there unless you either set a space a
a defaut
> > | > > value in your Db or your html has the space in it
> > | > >
> > | > > Make sure the code looks like (on 1 line)
> > | > > <textarea rows="2" cols="20"><%=FP_FieldVal (fp_rs,
> > | > > "FirstName")%></textarea>
> > | > >
> > | > >
> > | > > --
> > | > >
> > | > > _____________________________________________
> > | > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> > | > > "Warning - Using the F1 Key will not break anything!" (-;
> > | > > To find the best Newsgroup for FrontPage support see:
> > | > >
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> > | > > _____________________________________________
> > | > >
> > | > >
> > | > > "Steve Spicer" <(E-Mail Removed)> wrote in
message
> > | > > news:560FDDEA-1162-433D-A950-(E-Mail Removed)...
> > | > > | This has always bugged me. If you create a textbox with an
initial value
> > | > > | which is a field value, like <% = FP_FieldVal (fp_rs,
"FirstName")%>
> > | > > then
> > | > > | when the form is live and you click in the text box when it's
empty
> > | > > (there
> > | > > | was no field value in the db) the cursor is on the second
character. If
> > | > > the
> > | > > | user doesn't manually backspace to the first character it loads
a value
> > | > > into
> > | > > | the database with a <space> first character. That can screw up
sorting
> > | > > | something fierce. It's not a problem when there is no initial
field
> > | > > value
> > | > > | coded into the text box or if you tab into the textbox. Try it.
> > | > > | Is there any kind of workaround?
> > | > >
> > | > >
> > | >
> > | >
> > | >
> >
> >
> >

Sure do when you view source. But how does the space get there?
I did change the value in the code to
<input type="text" name="T1" size="35"
value="<%=FP_FieldVal(fp_rs,"T2")%>"></td>
to eliminate the space beween fp_rs, and "T2" but that doesn't help.
The browser reads that as a space when the empty field is called from the
db. That's my whole problem. The user has to backspace to fill in the textbox
without a space.

"Bob Lehmann" wrote:

> You have a space in the value -
> <input type="text" name="T2" size="35" value=" ">Bob Lehmann"Steve
> Spicer" <(E-Mail Removed)> wrote in message
> news:BF853B43-C9AF-4049-BFD8-(E-Mail Removed)...
> > I've posted code at http://www.spicerweb.org/tesadd.asp for that page and
> for
> > the editestdb.asp page that the hyperlink takes you to. That page is the
> > first step in an edit database page which is not completed for this test.
> The
> > whole routine for pages to editing the database I created several years
> ago
> > for a work "rolodex" and it's bugged me since then that the cursor would
> be
> > placed on the second character.
> > The tutorial for creating the edit pages is at
> > http://spicerweb.org/tutorial/tutorial/tutorial.htm
> >
> > "Stefan B Rusynko" wrote:
> >
> > > Post a code snipped of your form at the top of
> http://www.spicerweb.org/tesadd.asp
> > >
> > > --
> > >
> > > _____________________________________________
> > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> > > "Warning - Using the F1 Key will not break anything!" (-;
> > > To find the best Newsgroup for FrontPage support see:
> > > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> > > _____________________________________________
> > >
> > >
> > > "Steve Spicer" <(E-Mail Removed)> wrote in message
> news:06A29BC5-B397-413B-8F48-(E-Mail Removed)...
> > > | That doesn't work either. You can go to
> > > | http://www.spicerweb.org/tesadd.asp
> > > | to see what I mean. You will need to click on the hyperlink in the
> results
> > > | to take you to the edit page where you can click in the empty last
> name
> > > | textbox.
> > > | The cursor will be on the second character.
> > > |
> > > | "Jon Spivey" wrote:
> > > |
> > > | > to be sure you could trim the value
> > > | > <textarea rows="2" cols="20"><%=trim(FP_FieldVal (fp_rs,
> > > | > "FirstName"))%></textarea>
> > > | >
> > > | > --
> > > | > Cheers,
> > > | > Jon
> > > | > Microsoft MVP
> > > | >
> > > | > "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> > > | > news:%(E-Mail Removed)...
> > > | > > There should not be a space there unless you either set a space a
> a defaut
> > > | > > value in your Db or your html has the space in it
> > > | > >
> > > | > > Make sure the code looks like (on 1 line)
> > > | > > <textarea rows="2" cols="20"><%=FP_FieldVal (fp_rs,
> > > | > > "FirstName")%></textarea>
> > > | > >
> > > | > >
> > > | > > --
> > > | > >
> > > | > > _____________________________________________
> > > | > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> > > | > > "Warning - Using the F1 Key will not break anything!" (-;
> > > | > > To find the best Newsgroup for FrontPage support see:
> > > | > >
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> > > | > > _____________________________________________
> > > | > >
> > > | > >
> > > | > > "Steve Spicer" <(E-Mail Removed)> wrote in
> message
> > > | > > news:560FDDEA-1162-433D-A950-(E-Mail Removed)...
> > > | > > | This has always bugged me. If you create a textbox with an
> initial value
> > > | > > | which is a field value, like <% = FP_FieldVal (fp_rs,
> "FirstName")%>
> > > | > > then
> > > | > > | when the form is live and you click in the text box when it's
> empty
> > > | > > (there
> > > | > > | was no field value in the db) the cursor is on the second
> character. If
> > > | > > the
> > > | > > | user doesn't manually backspace to the first character it loads
> a value
> > > | > > into
> > > | > > | the database with a <space> first character. That can screw up
> sorting
> > > | > > | something fierce. It's not a problem when there is no initial
> field
> > > | > > value
> > > | > > | coded into the text box or if you tab into the textbox. Try it.
> > > | > > | Is there any kind of workaround?
> > > | > >
> > > | > >
> > > | >
> > > | >
> > > | >
> > >
> > >
> > >
>
>
>

Do you have a space in the field in the database?

See Jon Spivey reply on how to make sure that you do not have a leading or trailing spaces in field
content.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


"Steve Spicer" <(E-Mail Removed)> wrote in message
news:B928639B-A654-4DD2-8D81-(E-Mail Removed)...
> Sure do when you view source. But how does the space get there?
> I did change the value in the code to
> <input type="text" name="T1" size="35"
> value="<%=FP_FieldVal(fp_rs,"T2")%>"></td>
> to eliminate the space beween fp_rs, and "T2" but that doesn't help.
> The browser reads that as a space when the empty field is called from the
> db. That's my whole problem. The user has to backspace to fill in the textbox
> without a space.
>
> "Bob Lehmann" wrote:
>
>> You have a space in the value -
>> <input type="text" name="T2" size="35" value=" ">Bob Lehmann"Steve
>> Spicer" <(E-Mail Removed)> wrote in message
>> news:BF853B43-C9AF-4049-BFD8-(E-Mail Removed)...
>> > I've posted code at http://www.spicerweb.org/tesadd.asp for that page and
>> for
>> > the editestdb.asp page that the hyperlink takes you to. That page is the
>> > first step in an edit database page which is not completed for this test.
>> The
>> > whole routine for pages to editing the database I created several years
>> ago
>> > for a work "rolodex" and it's bugged me since then that the cursor would
>> be
>> > placed on the second character.
>> > The tutorial for creating the edit pages is at
>> > http://spicerweb.org/tutorial/tutorial/tutorial.htm
>> >
>> > "Stefan B Rusynko" wrote:
>> >
>> > > Post a code snipped of your form at the top of
>> http://www.spicerweb.org/tesadd.asp
>> > >
>> > > --
>> > >
>> > > _____________________________________________
>> > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> > > "Warning - Using the F1 Key will not break anything!" (-;
>> > > To find the best Newsgroup for FrontPage support see:
>> > > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
>> > > _____________________________________________
>> > >
>> > >
>> > > "Steve Spicer" <(E-Mail Removed)> wrote in message
>> news:06A29BC5-B397-413B-8F48-(E-Mail Removed)...
>> > > | That doesn't work either. You can go to
>> > > | http://www.spicerweb.org/tesadd.asp
>> > > | to see what I mean. You will need to click on the hyperlink in the
>> results
>> > > | to take you to the edit page where you can click in the empty last
>> name
>> > > | textbox.
>> > > | The cursor will be on the second character.
>> > > |
>> > > | "Jon Spivey" wrote:
>> > > |
>> > > | > to be sure you could trim the value
>> > > | > <textarea rows="2" cols="20"><%=trim(FP_FieldVal (fp_rs,
>> > > | > "FirstName"))%></textarea>
>> > > | >
>> > > | > --
>> > > | > Cheers,
>> > > | > Jon
>> > > | > Microsoft MVP
>> > > | >
>> > > | > "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
>> > > | > news:%(E-Mail Removed)...
>> > > | > > There should not be a space there unless you either set a space a
>> a defaut
>> > > | > > value in your Db or your html has the space in it
>> > > | > >
>> > > | > > Make sure the code looks like (on 1 line)
>> > > | > > <textarea rows="2" cols="20"><%=FP_FieldVal (fp_rs,
>> > > | > > "FirstName")%></textarea>
>> > > | > >
>> > > | > >
>> > > | > > --
>> > > | > >
>> > > | > > _____________________________________________
>> > > | > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> > > | > > "Warning - Using the F1 Key will not break anything!" (-;
>> > > | > > To find the best Newsgroup for FrontPage support see:
>> > > | > >
>> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
>> > > | > > _____________________________________________
>> > > | > >
>> > > | > >
>> > > | > > "Steve Spicer" <(E-Mail Removed)> wrote in
>> message
>> > > | > > news:560FDDEA-1162-433D-A950-(E-Mail Removed)...
>> > > | > > | This has always bugged me. If you create a textbox with an
>> initial value
>> > > | > > | which is a field value, like <% = FP_FieldVal (fp_rs,
>> "FirstName")%>
>> > > | > > then
>> > > | > > | when the form is live and you click in the text box when it's
>> empty
>> > > | > > (there
>> > > | > > | was no field value in the db) the cursor is on the second
>> character. If
>> > > | > > the
>> > > | > > | user doesn't manually backspace to the first character it loads
>> a value
>> > > | > > into
>> > > | > > | the database with a <space> first character. That can screw up
>> sorting
>> > > | > > | something fierce. It's not a problem when there is no initial
>> field
>> > > | > > value
>> > > | > > | coded into the text box or if you tab into the textbox. Try it.
>> > > | > > | Is there any kind of workaround?
>> > > | > >
>> > > | > >
>> > > | >
>> > > | >
>> > > | >
>> > >
>> > >
>> > >
>>
>>
>>

No. No spaces in the Access database. I checked that. The field is not
required and zero length is allowed if that makes any difference. In this
test case I let FP create the database.

"Thomas A. Rowe" wrote:

> Do you have a space in the field in the database?
>
> See Jon Spivey reply on how to make sure that you do not have a leading or trailing spaces in field
> content.
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
> ==============================================
> Agents Real Estate Listing Network
> http://www.NReal.com
> ==============================================
>
>
> "Steve Spicer" <(E-Mail Removed)> wrote in message
> news:B928639B-A654-4DD2-8D81-(E-Mail Removed)...
> > Sure do when you view source. But how does the space get there?
> > I did change the value in the code to
> > <input type="text" name="T1" size="35"
> > value="<%=FP_FieldVal(fp_rs,"T2")%>"></td>
> > to eliminate the space beween fp_rs, and "T2" but that doesn't help.
> > The browser reads that as a space when the empty field is called from the
> > db. That's my whole problem. The user has to backspace to fill in the textbox
> > without a space.
> >
> > "Bob Lehmann" wrote:
> >
> >> You have a space in the value -
> >> <input type="text" name="T2" size="35" value=" ">Bob Lehmann"Steve
> >> Spicer" <(E-Mail Removed)> wrote in message
> >> news:BF853B43-C9AF-4049-BFD8-(E-Mail Removed)...
> >> > I've posted code at http://www.spicerweb.org/tesadd.asp for that page and
> >> for
> >> > the editestdb.asp page that the hyperlink takes you to. That page is the
> >> > first step in an edit database page which is not completed for this test.
> >> The
> >> > whole routine for pages to editing the database I created several years
> >> ago
> >> > for a work "rolodex" and it's bugged me since then that the cursor would
> >> be
> >> > placed on the second character.
> >> > The tutorial for creating the edit pages is at
> >> > http://spicerweb.org/tutorial/tutorial/tutorial.htm
> >> >
> >> > "Stefan B Rusynko" wrote:
> >> >
> >> > > Post a code snipped of your form at the top of
> >> http://www.spicerweb.org/tesadd.asp
> >> > >
> >> > > --
> >> > >
> >> > > _____________________________________________
> >> > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> >> > > "Warning - Using the F1 Key will not break anything!" (-;
> >> > > To find the best Newsgroup for FrontPage support see:
> >> > > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> >> > > _____________________________________________
> >> > >
> >> > >
> >> > > "Steve Spicer" <(E-Mail Removed)> wrote in message
> >> news:06A29BC5-B397-413B-8F48-(E-Mail Removed)...
> >> > > | That doesn't work either. You can go to
> >> > > | http://www.spicerweb.org/tesadd.asp
> >> > > | to see what I mean. You will need to click on the hyperlink in the
> >> results
> >> > > | to take you to the edit page where you can click in the empty last
> >> name
> >> > > | textbox.
> >> > > | The cursor will be on the second character.
> >> > > |
> >> > > | "Jon Spivey" wrote:
> >> > > |
> >> > > | > to be sure you could trim the value
> >> > > | > <textarea rows="2" cols="20"><%=trim(FP_FieldVal (fp_rs,
> >> > > | > "FirstName"))%></textarea>
> >> > > | >
> >> > > | > --
> >> > > | > Cheers,
> >> > > | > Jon
> >> > > | > Microsoft MVP
> >> > > | >
> >> > > | > "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> >> > > | > news:%(E-Mail Removed)...
> >> > > | > > There should not be a space there unless you either set a space a
> >> a defaut
> >> > > | > > value in your Db or your html has the space in it
> >> > > | > >
> >> > > | > > Make sure the code looks like (on 1 line)
> >> > > | > > <textarea rows="2" cols="20"><%=FP_FieldVal (fp_rs,
> >> > > | > > "FirstName")%></textarea>
> >> > > | > >
> >> > > | > >
> >> > > | > > --
> >> > > | > >
> >> > > | > > _____________________________________________
> >> > > | > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> >> > > | > > "Warning - Using the F1 Key will not break anything!" (-;
> >> > > | > > To find the best Newsgroup for FrontPage support see:
> >> > > | > >
> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> >> > > | > > _____________________________________________
> >> > > | > >
> >> > > | > >
> >> > > | > > "Steve Spicer" <(E-Mail Removed)> wrote in
> >> message
> >> > > | > > news:560FDDEA-1162-433D-A950-(E-Mail Removed)...
> >> > > | > > | This has always bugged me. If you create a textbox with an
> >> initial value
> >> > > | > > | which is a field value, like <% = FP_FieldVal (fp_rs,
> >> "FirstName")%>
> >> > > | > > then
> >> > > | > > | when the form is live and you click in the text box when it's
> >> empty
> >> > > | > > (there
> >> > > | > > | was no field value in the db) the cursor is on the second
> >> character. If
> >> > > | > > the
> >> > > | > > | user doesn't manually backspace to the first character it loads
> >> a value
> >> > > | > > into
> >> > > | > > | the database with a <space> first character. That can screw up
> >> sorting
> >> > > | > > | something fierce. It's not a problem when there is no initial
> >> field
> >> > > | > > value
> >> > > | > > | coded into the text box or if you tab into the textbox. Try it.
> >> > > | > > | Is there any kind of workaround?
> >> > > | > >
> >> > > | > >
> >> > > | >
> >> > > | >
> >> > > | >
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>
>