Auto shrink/grow fields

[Thompyt]

How can I stop a field moving down when another field auto grows?
All fields can autogrow/shrink
Layout
Field1 Field2


Field3

xxx = Field Value
..... = Space holders since the site deletes the spaces

This is what I get:

xxxxx...................xxxxxxxxxxx
...........................xxxxxxxxxxxx
xxxxxxx

This is what I want:

xxxxx..................xxxxxxxxxxx
xxxxxxx...............xxxxxxxxxxxx

Thanks

[June7]

What do you mean 'the site deletes the spaces'? This is downloaded data?

What you show is 3 records.

How should Access know to combine the last 2 records?

[Thompyt]

There is no combining of fields.
What I get
11111111 3333333333
3333333333
222222

What I would like:
111111 33333333333
222222 33333333333

I think I was using the tab to get the spaces and the site doesn't like it.

Each one is its own disparate field. If you could combine fields 1 and 2 then that would work also.

[June7]

I said combine records, not combine fields. If the data is in table as 3 records, how should Access know to output as 2 records?

I don't know what you mean by 'using the tab to get the spaces and the site doesn't like it'.

[Thompyt]

If I put more than on space after a word (like seven) the website will remove the extra spaces. Same as goes with the use of tab on the web site.

I am looking into combining the records for fields 1 and 2, that would solve the problem. Concatenate?

Combined_Records:[Change Type] & " " [Soft Level]?

[June7]

Sorry, I am lost. What does a web site have to do with this? Are you using a web database?

Can't combine records with a simple expression. That would concatenate the two fields of a single record.

This sounds like a design flaw in data entry process. Fix the flaw.

[Thompyt]

Apologies,
I was referencing this website about formatting difficulties. I was trying to separate the fields (1111, 2222, 3333) with spaces and tabs. It doesn't work.

I want to combine 2 fields from 1 record in the output of a report. Concatenate seems to be the ticket for what I was originally trying to do.

[Thompyt]

I have the concatenate figured out. What if I wanted a carriage return between the data?

[Thompyt]

I have the concatenate figured out. I figured out by lengthening the spaces between the field ] & " " & [ I can set up the lines (make a "carriage" return) between the fields if I want. Unless there is a better way, I would consider this thread closed.

Thanks

[June7]

Can force carriage return in a textbox or query expression with:

[fieldname1] & Chr(13) & Chr(10) & [fieldname2]

In VBA can use:

[fieldname1] & vbCrLf & [fieldname2]

[Thompyt]

Cool, Thanks!!

Much easier