Lebans.com CanGrow

  • Thread starter Thread starter David
  • Start date Start date
D

David

Sorry if the content has been posted before, but I have had problems with my
ISP's news sever.


Hi all.



Could somebody please advise me how you write code to manipulate the CanGrow
function so that I can shrink and grow textboxes as I do not appear to be
able to find a write-up on this function.



The main problem at the moment is:-



If say, a memo box has three lines of information in it. It will not push
down the memo box beneath it. Hence, memo box two is obscuring information
in memo box one.



My objective once I understand how this function works is to place two
columns of text boxes, next to each other (titled old / Updated) the text
/memo boxes would be one on top of each other. (I take it that the function
works similar to Access report shrink and grow function, i.e. where you must
avoid overlapping text boxes)



The final part of my requirement would be that when the data is identical,
say in txtOldMod1 and txtUpdatedMod1 both text boxes in the horizontal plane
would not be displayed, and no gap would be left.



Any help on this subject would be most appreciated .
 
Perhaps you might consider using an Unbound TextBox control(s) and
simply cocatentate the contents of your current controls into one. Then
the CanGrow/Shrink property will work as you desire.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Hi Stephen
Did you mean something like:-
private sub form_current()

fcangrow me. txtextrainfo
if [col1] = [col2] then
me.txtextrainfo =[col1] & chr$(13) &chr$(10) & [col2]
else
me.txtextrainfo.height = 0 (works ok it shrinks)
'me.txtextrainfo = null did not work
end if
end sub

If the above is what you was suggesting, then it is not what I am looking
for.
From the above code why does the text box not shrink with = null?
Could you explain the points I mentioned in my previous posting regarding
the way this function works, as I am taking it that it has the same
functionally as access's report grow and shrink?

Thank you
Dave
 
Back
Top