Hi There,
I hope this isn't a dumb question, but I have made myself
a nice form and the information that is in the first
record, most of it needs to be carried over to the next
form, and I would prefer not to retype it, just have it
automatically show up in the next record and then I can
make my changes in this next record, is there a way I can
get it to carry the info over to other records? Also
another question, for formatting, is there a way to get
rid of just the side and top borders of my text box and
just leave the bottom border? Thanks for your help.

>-----Original Message-----
>Hi There,
>I hope this isn't a dumb question, but I have made myself
>a nice form and the information that is in the first
>record, most of it needs to be carried over to the next
>form, and I would prefer not to retype it, just have it
>automatically show up in the next record and then I can
>make my changes in this next record, is there a way I can
>get it to carry the info over to other records? Also
>another question, for formatting, is there a way to get
>rid of just the side and top borders of my text box and
>just leave the bottom border? Thanks for your help.
>.
See Knowledgebase article: ACC2000: Fill Record with Data
from Previous Record Automatically. It's at
http://support.microsoft.com/default.aspx?scid=kb;en-
us;210236&Product=acc#appliesto. There are Knowledgebase
articles for other versions, too.

Don't see any way for the formatting you desire except
positioning a line at the bottom of each text box. I
don't recommend it.

Roxie Aho
roxiea at usinternet.com

The closest thing to a text box without top and side borders is the
"Chiseled" effect, which can be set in the Special Effect property of the
text box.

--

Cheryl Fischer, MVP Microsoft Access



"Jolene" <(E-Mail Removed)> wrote in message
news:1049d01c43f52$1ba5b7d0$(E-Mail Removed)...
> Hi There,
> I hope this isn't a dumb question, but I have made myself
> a nice form and the information that is in the first
> record, most of it needs to be carried over to the next
> form, and I would prefer not to retype it, just have it
> automatically show up in the next record and then I can
> make my changes in this next record, is there a way I can
> get it to carry the info over to other records? Also
> another question, for formatting, is there a way to get
> rid of just the side and top borders of my text box and
> just leave the bottom border? Thanks for your help.

"Jolene" <(E-Mail Removed)> wrote in message
news:1049d01c43f52$1ba5b7d0$(E-Mail Removed)...
> Hi There,
> I hope this isn't a dumb question, but I have made myself
> a nice form and the information that is in the first
> record, most of it needs to be carried over to the next
> form, and I would prefer not to retype it, just have it
> automatically show up in the next record and then I can
> make my changes in this next record, is there a way I can
> get it to carry the info over to other records? Also
> another question, for formatting, is there a way to get
> rid of just the side and top borders of my text box and
> just leave the bottom border? Thanks for your help.

You can carry the current value of a control to the next
record by setting the .defaultvalue of the control to the
current .value of the control. Perhaps in the control's
AfterUpdate event.

To get just a bottom border for a textbox set the border
style to transparent and use a line control as the bottom
border.