Can Grow/Shrink?

[Lost500]

Hey everyone!

I have a report with two fields side by side I want the values to apear side by side regardless of how big/small they are. I've selected Yes for can grow/shrink on both fields but they stay where they are and if the value is too big it still cuts it off. How do I make the right field scoot to the left if the value for the left field is small and vice versa?

thanks for the help in advance!

 

[dhookom]

Can Grow is only for the height. If I understand correctly, you can do this with a single text box with a control source like:
[tt][blue]
=[Field1] & " " & [Field2]
[/blue][/tt]
You might need to change the name of this text box so it is not the name of a field.

Duane
Hook'D on Access
MS Access MVP

 

[Lost500]

Thanks dhookom,
That worked great for getting the two fields side by side!

is there something like =[Field1] & " " & Percent([Field2])
in order to make field two a percentage?

Thanks for all the help

 

[dhookom]

If [Field2] is a number, try:

=[Field1] & " " & Format([Field2],"Percent")

Duane
Hook'D on Access
MS Access MVP

 

[Lost500]

it was a calculated field of numbers and it worked! this is by far the longest formula i've entered into a text box on a report and it work greatly! Thank you so much.

on a side note.... i have a text field on my report that has numbers in it and when i use a sum() function in the footer it works fine unless there are null values... is there another sum function that will add numbers in a text field and not care if there are nulls?

i cannont format the field as a number because there were some people that didn't know about tek-tips.com working on this before me and entered some non number values! (which i'm working on it just takes ohhhh forever to go through a couple hundred thousand records!)

 

[dhookom]

Nulls don't generally cause issues with Sum(). I would clean the data and then use Sum(). If this wasn't possible, I would try something like the following where column3 is the text field:

=Sum(IIf(IsNumeric([Column3]),Val([column3]),0))

Duane
Hook'D on Access
MS Access MVP