Solved

MSFlexGrid

Posted on 2003-11-19
8
1,705 Views
Last Modified: 2012-08-13
i success insert data into MSFlexgrid field. but leading space occur for each field. how should i remove the leading space and insert data located in left side.

i use LTRIM function to remove leading spaces but not working.
0
Comment
Question by:cyseng10
8 Comments
 

Expert Comment

by:kapil_mohta
ID: 9784672
could u provide the code u r using to insert the data ?

Kapil
0
 
LVL 18

Expert Comment

by:Cluskitt
ID: 9786446
Format the field for text only. Will post back later to tell you how you can do this.
0
 
LVL 18

Expert Comment

by:Cluskitt
ID: 9788181
Try:
MSFlexgrid.CellAlignment=flexAlignLeftCenter
If that doesn't work, please post the part of the code where you receive the data, and where you insert it into the grid.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:cyseng10
ID: 9792257
i read data from text file and using Additem function insert data into MSFlexGrid Field.

the data might long. when i insert into field. i can't disply full length of data. how do i apply scrollbar to view full length of data?

the CellAlignment function and convert to text format is not working.
0
 
LVL 18

Expert Comment

by:Cluskitt
ID: 9796003
MsFlexgrid.Wordwrap=true
MsFlexgrid.colwidth=Len(text)/2
MsFlexgrid.rowheight=20
This will adjust the size of the cell to two lines (You may have to fine-tune the rowheight property).
You might also want to make checks to see if the 2nd line won't reduce the colwidth from a previous text entry, but basically, that should take care of the display. Note that you can also divide it by 3 lines, etc. Just adjust as desired.
You can also make a variable to test the longest text length being inserted, and in the end adjust the colwidth.
Another possibility is, after testing the longest length being inserted, test it in a switch case statement, and from zero to value x, divide it in 2 lines, from x+1 to y, divide in 3, etc... Again, adjust as you desire.

Now, about the text part, it would be better if you could post the code for getting the text from the file, and for putting into the MSFlexgrid. That way, we could see how you are doing it, correct any possible mistakes along the way, and get a better understanding of how it works. If you could post a sample of the text file as well, it would be helpful (just a few lines should be enough).
0
 
LVL 1

Author Comment

by:cyseng10
ID: 10008980
Please closed the question as found solution by myself.

thank you for replying.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 10025284
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now