By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 2,082 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

display of long text

P: n/a
hi!!!

i need to display a disclaimer which is two page in length in a word
document. i also need to format the text. the idea is something as
follows

on opening the application, a form which serves as splash screen with
the disclaimer of the application is shown. now the problem i am
running into is in the display of the disclaimer which is really two
page long and it should be formatted too. using a textbox seems not
possible as it doesn't accomodate the whole of disclaimer. the control
in which the disclaimer is to be displayed need to have vertical
scrollbar. i don't have rich textbox. is there anyway i can do it using
any other control. can it be done using subform or subreport?

there is another weird problem i am facing and this is related to main
form and a linked subform. both the main and subform are bound forms.
the subform is linked to main form by using the masterkey and child
key. the weird thing i notice is that when any data is entered in the
subform which entering any data in the mainform the record get saved in
the subform without any valid related record being saved in the main
table leading to orphan record. how do u control and set it in such a
way that only if a record is being saved in the main table (from the
main form), the data entered in the subform need to be stored in the
related table, when no data is entered in the mainform and if any data
is entered in the subform it shouldn't be stored.

thanx in advance. have a great day

bala

Nov 13 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a
On 21 Feb 2005 11:09:10 -0800, "bala" <ba*****@gmail.com> wrote:

Rich textbox comes with Windows. You should have it.
An alternative is a Webbrowser control; comes with IE.

Your database design needs to be enhanced. Build a referential
integrity link between the parent table and the child table, and check
the box to enforce it. Also the foreign key value in the child table
should typically be a required field.

-Tom.

hi!!!

i need to display a disclaimer which is two page in length in a word
document. i also need to format the text. the idea is something as
follows

on opening the application, a form which serves as splash screen with
the disclaimer of the application is shown. now the problem i am
running into is in the display of the disclaimer which is really two
page long and it should be formatted too. using a textbox seems not
possible as it doesn't accomodate the whole of disclaimer. the control
in which the disclaimer is to be displayed need to have vertical
scrollbar. i don't have rich textbox. is there anyway i can do it using
any other control. can it be done using subform or subreport?

there is another weird problem i am facing and this is related to main
form and a linked subform. both the main and subform are bound forms.
the subform is linked to main form by using the masterkey and child
key. the weird thing i notice is that when any data is entered in the
subform which entering any data in the mainform the record get saved in
the subform without any valid related record being saved in the main
table leading to orphan record. how do u control and set it in such a
way that only if a record is being saved in the main table (from the
main form), the data entered in the subform need to be stored in the
related table, when no data is entered in the mainform and if any data
is entered in the subform it shouldn't be stored.

thanx in advance. have a great day

bala


Nov 13 '05 #2

P: n/a

bala wrote:
hi!!!

i need to display a disclaimer which is two page in length in a word
document. i also need to format the text. the idea is something as
follows

on opening the application, a form which serves as splash screen with
the disclaimer of the application is shown. now the problem i am
running into is in the display of the disclaimer which is really two
page long and it should be formatted too. using a textbox seems not
possible as it doesn't accomodate the whole of disclaimer. the control in which the disclaimer is to be displayed need to have vertical
scrollbar. i don't have rich textbox. is there anyway i can do it using any other control. can it be done using subform or subreport?
Put an OLE frame on your form?
there is another weird problem i am facing and this is related to main form and a linked subform. both the main and subform are bound forms.
the subform is linked to main form by using the masterkey and child
key. the weird thing i notice is that when any data is entered in the
subform which entering any data in the mainform the record get saved in the subform without any valid related record being saved in the main
table leading to orphan record. how do u control and set it in such a
way that only if a record is being saved in the main table (from the
main form), the data entered in the subform need to be stored in the
related table, when no data is entered in the mainform and if any data is entered in the subform it shouldn't be stored.

Declare referential integrity between the two tables. Then if you try
to enter child data without an existing parent record, the insert will
automatically fail.

Nov 13 '05 #3

P: n/a
well the referential integrity is declared (that is checking the
enforce referencial integrity in the relationship) but it still doesn't
work

Nov 13 '05 #4

P: n/a
hey tom

how do i get to access rich textbox with windows.

well as i replied to earlier post the referential integrity is being
enforced but the foreign key value in the child table is not a required
field, must it be made required cos i thought referential integrity
declaration should be enough.

bala

Nov 13 '05 #5

P: n/a
well the referential integrity is declared (that is checking the
enforce referencial integrity in the relationship) but it still doesn't
work

Nov 13 '05 #6

P: n/a
hey tom

how do i get to access rich textbox with windows.

well as i replied to earlier post the referential integrity is being
enforced but the foreign key value in the child table is not a required
field, must it be made required cos i thought referential integrity
declaration should be enough.

bala

Nov 13 '05 #7

P: n/a
On 21 Feb 2005 14:49:34 -0800, "bala" <ba*****@gmail.com> wrote:

On the Toolbox, click on the last button (toolbox plus 3 dots), and
scroll down to Microsoft Rich Text Control.

-Tom.

hey tom

how do i get to access rich textbox with windows.

well as i replied to earlier post the referential integrity is being
enforced but the foreign key value in the child table is not a required
field, must it be made required cos i thought referential integrity
declaration should be enough.

bala


Nov 13 '05 #8

P: n/a
On 21 Feb 2005 14:49:34 -0800, "bala" <ba*****@gmail.com> wrote:

On the Toolbox, click on the last button (toolbox plus 3 dots), and
scroll down to Microsoft Rich Text Control.

-Tom.

hey tom

how do i get to access rich textbox with windows.

well as i replied to earlier post the referential integrity is being
enforced but the foreign key value in the child table is not a required
field, must it be made required cos i thought referential integrity
declaration should be enough.

bala


Nov 13 '05 #9

P: n/a
Tom the MS RTF control is included with the MS Development platforms.
There is a free RTF control here:
http://www.lebans.com/richtext.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:7s********************************@4ax.com...
On 21 Feb 2005 14:49:34 -0800, "bala" <ba*****@gmail.com> wrote:

On the Toolbox, click on the last button (toolbox plus 3 dots), and
scroll down to Microsoft Rich Text Control.

-Tom.

hey tom

how do i get to access rich textbox with windows.

well as i replied to earlier post the referential integrity is being
enforced but the foreign key value in the child table is not a requiredfield, must it be made required cos i thought referential integrity
declaration should be enough.

bala


Nov 13 '05 #10

P: n/a
Tom the MS RTF control is included with the MS Development platforms.
There is a free RTF control here:
http://www.lebans.com/richtext.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:7s********************************@4ax.com...
On 21 Feb 2005 14:49:34 -0800, "bala" <ba*****@gmail.com> wrote:

On the Toolbox, click on the last button (toolbox plus 3 dots), and
scroll down to Microsoft Rich Text Control.

-Tom.

hey tom

how do i get to access rich textbox with windows.

well as i replied to earlier post the referential integrity is being
enforced but the foreign key value in the child table is not a requiredfield, must it be made required cos i thought referential integrity
declaration should be enough.

bala


Nov 13 '05 #11

P: n/a
hi guys

thanx for the pointers.

bala

Nov 13 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.