Re: Forms 3.0 question
From: Ian Dixon <idixon_at_infocom.UUCP>
Date: 24 Nov 92 22:18:51 GMT
Message-ID: <432_at_infocom.UUCP>
Date: 24 Nov 92 22:18:51 GMT
Message-ID: <432_at_infocom.UUCP>
Albert L. Evans, IV (ae0i+_at_andrew.cmu.edu) wrote:
>
> Is it possible to center a string of text in a field and if so, how? Hopefull
y
> there is an easy way to do it, rather than having to resort to obscure SQL
> text manipulation functions. Thanks,
>
> Bert Evans
I've done this to get a screen heading centered in a field on the top line and it basically does involve using text manipulation. I'm writing this at home so I dont have the exact code but it uses LEN to get the string length, subtracts this from the field length and then LPADs the string with spaces (if I remember correctly). If it helps, I can get the exact code and post it although I would love to see a better solution
Regards
Ian
-- _________________________________________________________________ EMAIL =---> idixon_at_infocom.co.uk (Ian Dixon) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Received on Tue Nov 24 1992 - 23:18:51 CET