automatic field Width in report and horizontal alignment

[bs]

Hi all

I have 2 adjacent textboxes, txt1 and txt 2 (with controlsource) in a
report. I want to be able to automatic adjust the width of txt1 to accomodate
with data varying from 10 to 25 chars. Next I want the adjacent textbox to
align to the immediate right side of txt1.

How to, VBA, Macro other?

 

[Chris Reveille]

I am not sure if this is what you want but try concatenating txt1 and txt 2.
In your source query put
Txt1-2:[txt1]&" "&[txt2]
Use Txt1-2 in your report

 

[bs]

Dont quite get it. Add a new field called txt1-2 to my query or how?

"Chris Reveille" skrev:

I am not sure if this is what you want but try concatenating txt1 and txt 2.
In your source query put
Txt1-2:[txt1]&" "&[txt2]
Use Txt1-2 in your report

Hi all

I have 2 adjacent textboxes, txt1 and txt 2 (with controlsource) in a
report. I want to be able to automatic adjust the width of txt1 to accomodate
with data varying from 10 to 25 chars. Next I want the adjacent textbox to
align to the immediate right side of txt1.

How to, VBA, Macro other?

 

[Chris Reveille]

I am assuming you are basing your report on a quyery which is based on your
table.

add a new field named "Txt1-2" to the query concatenating txt1 and txt2 with
a space between them
Txt1-2:[txt1]&" "&[txt2]

Dont quite get it. Add a new field called txt1-2 to my query or how?

"Chris Reveille" skrev:

I am not sure if this is what you want but try concatenating txt1 and txt 2.
In your source query put
Txt1-2:[txt1]&" "&[txt2]
Use Txt1-2 in your report

Hi all

I have 2 adjacent textboxes, txt1 and txt 2 (with controlsource) in a
report. I want to be able to automatic adjust the width of txt1 to accomodate
with data varying from 10 to 25 chars. Next I want the adjacent textbox to
align to the immediate right side of txt1.

How to, VBA, Macro other?

 

[bs]

got it. Thanks mate, solved the prob

"Chris Reveille" skrev:

I am assuming you are basing your report on a quyery which is based on your
table.

add a new field named "Txt1-2" to the query concatenating txt1 and txt2 with
a space between them
Txt1-2:[txt1]&" "&[txt2]

Dont quite get it. Add a new field called txt1-2 to my query or how?

"Chris Reveille" skrev:

I am not sure if this is what you want but try concatenating txt1 and txt 2.
In your source query put
Txt1-2:[txt1]&" "&[txt2]
Use Txt1-2 in your report


:

Hi all

I have 2 adjacent textboxes, txt1 and txt 2 (with controlsource) in a
report. I want to be able to automatic adjust the width of txt1 to accomodate
with data varying from 10 to 25 chars. Next I want the adjacent textbox to
align to the immediate right side of txt1.

How to, VBA, Macro other?

 

[Chris Reveille]

Glad to help out.

got it. Thanks mate, solved the prob

"Chris Reveille" skrev:

I am assuming you are basing your report on a quyery which is based on your
table.

add a new field named "Txt1-2" to the query concatenating txt1 and txt2 with
a space between them
Txt1-2:[txt1]&" "&[txt2]

Dont quite get it. Add a new field called txt1-2 to my query or how?

"Chris Reveille" skrev:

I am not sure if this is what you want but try concatenating txt1 and txt 2.
In your source query put
Txt1-2:[txt1]&" "&[txt2]
Use Txt1-2 in your report


:

Hi all

I have 2 adjacent textboxes, txt1 and txt 2 (with controlsource) in a
report. I want to be able to automatic adjust the width of txt1 to accomodate
with data varying from 10 to 25 chars. Next I want the adjacent textbox to
align to the immediate right side of txt1.

How to, VBA, Macro other?