Overflow of data into new field 1

[tag141]

I have a table with three fields. data1, data2, data3. The user is to click a checkbox which will populate the first field. The checkbox may say "Address" and the address may be 5 lines long. Then they check another box "delivery" which is 6 lines long. I only want my db field to be 10 lines long (to print on a report) so I want the eleventh line to go into data2 (so it doesn't push data off the report). I am using an SQL to insert the data from the checkboxes into the table.

I know this is possible but with my limited knowledge it's become a brick wall. Any ideas?

Unless anyone knows about a report writer that can display a box of data that can grow sideways!!

TIA

 

[dhookom]

Stephen Lebans has text boxes that can grow sideways. Search

http://www.lebans.com

for lots of solutions.

What you are actually attempting to do and why is beyond my old brain.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[tag141]

Sorry, I've looked over my posts and feel I am quite good at not explaining myself very well. It's actually more about the reports that come with things like access and vb but I can't find an answer anywhere.
If I put a box on a form and populate it from a field from a table, it shows what is in the field. If that field is an address, lets say, that is eight lines long (street, suburb, zip etc) but the box on the form can't grow, you can cut the bottom off the address. By checking 'can grow' the box can accomodate all the lnes. What I want is to fix the hieght of the box to say, five lines, and have the other three start a new column in that box. If the box can grow, it will push whatever is below it down, therefore stuffing p the format of the report. Me, I don't think it's possible without severe coding which is waaaay beyond me but thanks anyway.

 

[dhookom]

I don't know why you would place different pieces of data that should be in different fields into a single field. Also, text boxes on forms can display a scroll bar to view all contents and text boxes on reports can be set to grow vertically to accomodate all text.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[tag141]

I do appreciate your replies. I don't think this can be done but...
My form works fine and my textbox has scrollbars but you can't have scroll bars on a printed form.
My report is to fit on a page of A5 and only be one A5 page long. I have a report header and a report footer and the space in between is only 10 lines. That is fine if the information in my field takes up 10 lines or less. However, if it is 11 lines and the textbox (on my report) is set to 'can grow', it will show those 11 lines but now my report will be bigger than A5 by 1 line as it will push the footer down by one line. What I was hoping was that I could say 'keep the textbox to 10 lines and start a new column within the textbox to show that 11th line'. Every report writer I have demo'd or looked at is just like the m$ report writer.

Thanks for trying anyway.

 

[earthandfire]

It might be worth investigating a third party Rich Text Format ActiveX control. This would provide, at the very least, a columns feature , so that the text would flow automatically from one column to the next.

 

[dhookom]

Did you search

http://www.lebans.com?

Stephen is the master of formatting text and graphics in forms and reports.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[tag141]

dhookom,

given you a star for being patient and helping me with this problem. I haven't sorted it out yet but I'm sure I'm getting nearer an answer. SQL server 2003 allows reports to have 'snaking' textboxes that go from right to left. I don't use SQL server but if they can do it, I'm sure it can be done in VB.

Thanks again.