how do you match dyamically a textfield with all memo fields with the same bold font

[GSTA]

I have tables that have one column with a bold text in a text field. This refers to a specification number. Another field is a memo field that contains the bold specification number and my information. there will be more memo fields with the same specification number than the text field.

I have a list box on a form where the user selects the spec this is placed a a table. I want the memo field to load all memo records containing the spec number in the text field. Any ideas.

As I will not know what the user will load I don't use a query

[Delerna]

If you need to select records from a table based on a data like that, then that data really should have a field all of its own and not be part of a memo field.


Having said that it can be done but you need some reliable way to extract the parameter from the memo as it's own field in a query
and then use that. Without seeing the data I can't suggest one and it's not usually easy or straight forward.

You could also use like i suppose

...
WHERE memoField like "%123456%"
 

but I don't really recommend it.
Just giving you options and letting you decide for yourself



PS
I don't know how your are going to do it if you don't use a query in one form or another?

[GSTA]

My problem is that the data I want associated in the field is too large for a text field. Imagine a field that could contain half a page of text. In excel I could probably use the match function. Another problem is the fact memo fields cannot be used for a list box.My original idea. I have looked through this site to come up with ideas. Still no luck

[Delerna]

Another field is a memo field that contains the bold specification number and my information. there will be more memo fields with the same specification number than the text field

No, I wasn't very clear, I was talking about your specification number having its own field and not included as part of the memo field. So you would have two fields instead of one
one for the specification code and one for your memo

Then its a simple matter of selecting all the records where the spec code is equal to the one you are interrested in.

[GSTA]

okay,what I wanted to do was the following:
field 1 named SpecID is a text field the data would be say 9.2.3.5 Heat Treatment then another field called Spec Memo1 which could contain the same bold 9.2.3.5 and the data for this. Because there could be potentially so much information related to 9.2.3.5 I wanted to use 9.2.3.5 numerous times in the memo field to capture all of the data. My list boxes have are on a form and I select the SpecID field that contains only the 9.2.3.5 (and its brief description) and tranfer this over to another list box than places this in my table. Because memo fields cannot use list boxes I have to "split up" my data and have the destination table have the ability to match all memo fields that reference the same number as the SpecID field and place them in the destination table. Because this is dynamic I am not able to figure out how to do this. If it was not dynamic then a query would be more straightforward. I hope this makes more sense

[Delerna]

hmm, contemplating your post.
Perhaps if you can describe to me what it is you need to do, without describing the database itself, just the task. I am having difficulty choosing between several options because its still not absolutely clear to me what you are doing.

I don't want to give you an answer that is way off the mark

[GSTA]

Thanks. I have many tables all based on one set of specifications. Each table will have a text field called SpecID and one memo field MemoID. It so happens that the specification numbers and description will be in the text field. These are in bold - but do not have to be per se. The memo field will also have the specification number, description, and much more text. If one textID field is chosen,I want a means to dynamically fill the memo field with all the memo fields that have the same specification number in the memo field as there is in the text field.