Multi-line scrollable text boxes??

[mbrost]

Hi All,

I'm a noobie with Access, and on my form which displays Account information, I also want to display the multiple Addresses this account can have. I can't find any type of scrollable text box (something to look like a spreadsheet), and I know it's not a list box I need to use.

How do I create this and what is it called? I tried using a data grid but I dont think that is it either

Also, my scrolling text icon on the toolbox is greyed out, not sure why.

Please help!

Thanks,

Mike

 

[Pat Hartman]

I'm not sure I understand the question but you can size textboxes by dragging (or specifically setting their height property) so that they can show multiple lines of text. In a report, these textboxes can be set to be expandable vertically as necessary but on a form, they are fixed unless you write your own code to change their height.

 

[godofhell]

Try using a memo field to store your addresses and setting the scoll properties accordingly

 

[ThreeCrow]

I would use multiple subForms set as Continuous Forms
Use a Combobox or ListBox to Filter your records.

Example:

Main Form:
ComboBox or ListBox to Filter your Records

subForm1: Account Names (or a ListBox)

subForm2: Account Address

subForm3: Account Contacts & PhoneNumbers

Hope this helps

 

[mbrost]

I'm not sure I understand the question .

Ok,

The relationship i have is 1 Account can have Many Addresses.

My form contains Account information, but I also want to display ALL addresses the Account might have (it could be 1, or it could be 3 or more).

Whats the best way to do this besides having a bunch of text boxes -- is there a way to have scrollable SEPARATE text boxes so all the addresses will display on the form??

Thanks for any help!

 

[Pat Hartman]

The best solution is to use a subform in continuous or datasheet view.

 

[mbrost]

Great thanks!

This is my first Access project... normally I do just oracle stuff, but never any forms work