automatic field Width in report and horizontal alignment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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


bs said:
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?
Click to expand...
Click to expand...
 
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]


bs said:
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


bs said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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]


bs said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Glad to help out.

bs said:
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]


bs said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top