Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Forms & Form designer
The table is accessed by others and the packing only occurs when it can be reopened exclusively. This causes the grid to blank out (no lines, nothing). Hilmar's and Trey's solution - though I feel it shouldn't need to come to that - was the best solution.
>Notwithstanding advice you've received in this thread, I'm curious why you have to disassociate your table from the grid at all when you pack it. Surely you'd just see the grid "twitch" as records are packed? Unless "myTable" is a different table from your original. Now I've never packed a table while it's showing in a grid, so I don't know if there are undesirable side-effects.
>
>Just curious.
>
>Terry (McD)
>
>>I'm resetting the RecordSource to "" and then to "MyTable" but the columns resize to what I think is the default size of the field lengths. What gives? I don't want to have to put a bunch of column widths into the grid. Why do they resize? Thanks!
>>
>>Regards, Renoir
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only