Ok, but you need to be more detailed about where the table is placed within the report definition. Is it in the page header, page footer, or body? ...

Well, for this purpose, I finally figured out how to overcome the formatting problem using the Format string, so now I don't need this particular solution, however... I...

I'm not sure I understand what your saying... Can you clarify exactly what you mean? Is the table not appearing in the same location on...

Ok then, with so many fields, perhaps you could find some way to narrow it down to just 4 or 5 tables or so? Perhaps find some kind...

Just a thought, and again, testing for performance implications would be essential, but perhaps you just have ONE extra table, capable of accommodating any/all OLD records from the various tables,...

GSquared,

My concern was with any processes that replaced any more than 2 spaces with none, which has a potential problem, as I pointed out previously.

With regard to your example of...

GSquared,

The reason I wasn't all that worried about performance is because this kind of fixing is generally a one-time event, and even if it took an hour, the overall net...

Holy Alphabet, Batman !!!

Ryan, that's one of the slickest routines I've ever seen... Neato, peachy keen, cool, etc., etc. ...

WELL DONE !!!

Steve

(aka smunson)

:):):)

I'm not sure of ALL the implications, but why not have a table dedicated to "old" data, such that after a change, the "old" record is archived to the "old...

There is a potential pitfall here, folks: Any time there are exactly X spaces between words, where X is greater than 2, you have a problem with any...

One last thought. Limit the number of chars in the rightmost column, AND set the width of that column in the properties of the combo box such that...

I'm first trying to understand why you want to have code to populate a combo box from a recordset ??? Why not just make the query the Record...

See your other post topic for the query I tried to develop once I realized what you were looking for.

Steve

(aka smunson)

:):):)

First, this post is part of a cross-posting. Please don't post a topic twice. As to what you seek, it would appear you may just need...

Levsha_z,

You appear to have changed your requirement. First, you asked for:

Now, you're asking...