User Profile
Collapse
-
i can group all the field in the line, if one field grows, made every fields in that line grow? -
"Can grow" Fields height in report
i created a report in access. the output look like spreedsheet(eve ry field has solid border) there is one colunm have some fields have very long content. so i set all colunms to "can grow"
but in printing preview. there is the only the field with long contents grows. other fields in the same rows are still short than that one. which looks awful. can I make all the fields in that row the same height as that one?
t... -
Thanks a lot Mary, yes i tried first one, but since it is a such large file, it take at least 30 minutes to run replace, and my access can only run around 60000 replace each time. it ask me to modify registry, but it is locked.
Use VBA is good idea, but i am not that familiar with it. Anyway, thank you for your reply....Leave a comment:
-
-
how to import a delimited text file like this?
it is very large file, has 678000 rows.
but the txt file get is like that
"name","address ","zip","st ate"
="11",="aaa",=" 00001",="NY"
="22",="bbb",=" 00002",="CT"
="33",="ccc",=" 00003",="NJ"
="44",="ddd",=" 00001",="MA"...
No activity results to display
Show More
Leave a comment: