A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how to make textbox in access form display multi-paragraph textcontent?



 
 
Thread Tools Display Modes
  #1  
Old July 2nd, 2008, 02:56 AM posted to microsoft.public.access.forms
leontancfa
external usenet poster
 
Posts: 1
Default how to make textbox in access form display multi-paragraph textcontent?

Hi. I have a table with a MEMO field, so that I can put some
paragraphs of text in. Then I want to display the multi-paragraph text
in a bounded textbox in a form, but all the carriage returns were not
displayed. That meaning all the paragraphs were joined to one when
they are in the textbox.

How can I set the textbox to be able to display multi-paragraph text?
Do I have to use windows forms textbox?

The following is a sample of the text I put in the MEMO field. The
carriage returns are made by using "CHR(10) & CHR(13)"

If an insurer’s accounting policies do not require a liability
adequacy test that meets the minimum requirements of paragraph 16, the
insurer shall:

(a) determine the carrying amount of the relevant insurance
liabilities1 less the carrying amount of:

(i) any related deferred acquisition costs; and

(ii) any related intangible assets, such as those acquired in a
business combination or portfolio transfer (see paragraphs 31 and 32).
However, related reinsurance assets are not considered because an
insurer accounts for them separately (see paragraph 20).

(b) determine whether the amount described in (a) is less than the
carrying amount that would be required if the relevant insurance
liabilities were within the scope of IAS 37. If it is less, the
insurer shall recognise the entire difference in profit or loss and
decrease the carrying amount of the related deferred acquisition costs
or related intangible assets or increase the carrying amount of the
relevant insurance liabilities.



  #2  
Old July 2nd, 2008, 03:34 AM posted to microsoft.public.access.forms
carriey
external usenet poster
 
Posts: 22
Default how to make textbox in access form display multi-paragraph text co

I'm not sure if this will help but in my forms I have my Memo Properties:

Enter Key Behaviour set to "New Line In Field" and I have no problems.

"leontancfa" wrote:

Hi. I have a table with a MEMO field, so that I can put some
paragraphs of text in. Then I want to display the multi-paragraph text
in a bounded textbox in a form, but all the carriage returns were not
displayed. That meaning all the paragraphs were joined to one when
they are in the textbox.

How can I set the textbox to be able to display multi-paragraph text?
Do I have to use windows forms textbox?

The following is a sample of the text I put in the MEMO field. The
carriage returns are made by using "CHR(10) & CHR(13)"

If an insurer’s accounting policies do not require a liability
adequacy test that meets the minimum requirements of paragraph 16, the
insurer shall:

(a) determine the carrying amount of the relevant insurance
liabilities1 less the carrying amount of:

(i) any related deferred acquisition costs; and

(ii) any related intangible assets, such as those acquired in a
business combination or portfolio transfer (see paragraphs 31 and 32).
However, related reinsurance assets are not considered because an
insurer accounts for them separately (see paragraph 20).

(b) determine whether the amount described in (a) is less than the
carrying amount that would be required if the relevant insurance
liabilities were within the scope of IAS 37. If it is less, the
insurer shall recognise the entire difference in profit or loss and
decrease the carrying amount of the related deferred acquisition costs
or related intangible assets or increase the carrying amount of the
relevant insurance liabilities.




  #3  
Old July 2nd, 2008, 07:23 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default how to make textbox in access form display multi-paragraph text content?

On Tue, 1 Jul 2008 18:56:18 -0700 (PDT), leontancfa
wrote:

How can I set the textbox to be able to display multi-paragraph text?


Set the Form's "Enter Key Behavior" property to "New line in field".

Use a Memo datatype in order to hold large amounts of text.

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.