INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Display Memo in combo box Or another option

Display Memo in combo box Or another option

(OP)
Hello, I need some ideas on the best solution for doing this. I have a memo field that I need to select from a combo box and display the result in a text box next to it which is easy. My problem is the text being long and the user having to scroll in a combo box to make a selection isn't very appealing but is the only option I can come up with. My question is how can I display several paragraphs or questions like below like you would in a combo box and be able to see all the text like below instead of one giant line of text. Thoughts!

Must be able to work with others in a teamwork environment:
A. Demonstrate the ability to cooperate with co-workers in all areas including safety, quality, production, and maintenance.
B. Completes all other job assignments that are issued by the Supervisor or Foreman.
C. Able and willing to work assigned overtime.
D. Maintain regular and predictable attendance.

Thanks,
SoggyCashew.....

RE: Display Memo in combo box Or another option

That's a lot of text to display in a combo box.
Can you just show the very first line in a combo box, and when chosen, display all of it in a text box?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

RE: Display Memo in combo box Or another option

Andy's idea is probably the way to go, here! The Memo Field is going to be truncated to 256 characters, when displayed in a Combobox, and even that is going to be bothersome in that you'll have to scroll a lot in order to see all of it.

If I had to do this, I'd use a Query as the RowSource, and have a calculated Field in it to only include X number of characters, something like this:

DisplayField: Left([MemoFieldName], 100)

Then include DisplayField in the Combobox RowSource instead of the Memo Field itself.

To show more characters or fewer characters, simply adjust the 100 in the above.

Hope this helps!

There's always more than one way to skin a cat!

All posts/responses based on Access 2003/2007

RE: Display Memo in combo box Or another option

(OP)
I’m having a heck of a time getting this database to work the way I want. Here is what Im wanting to do...

1) I have a main form (frm_DataEntryForm) which I need to select an employee
2) Then I have a subform (sfrm_EmployeeFunctions) that you need to select a “Function” and there are 9 functions to choose from in a combo box on this form.
3) Then on that (sfrm_EmployeeFunctions) I have a subform named (sfrm_FunctionRequirements) which I need to show a list of “Requirements”, “Completed” and “Date Completed”.
Now the issues I’m having is first I select an employee then I go to combo box and I select a function and there are several of the same. I cant get this section to work, I tried to create and run from a query but it shows several of the same entries AND when I do select a function I need it to show all the requirements associated with that function in the (sfrm_FunctionRequirements) so I can check if they were completed or not. Ideas?

Thanks,
SoggyCashew.....

RE: Display Memo in combo box Or another option

Did you found the solution to your original question? ("Display Memo in combo box Or another option")

I ask because this looks like totally unrelated new question...

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

RE: Display Memo in combo box Or another option

(OP)
Well It kinda has to do with the memo field so I didnt start a new thread. I decided to not go with the showing in a combo, well it shows in the combo cboFunction but hidden so no need to worry how it looks. I need the info from that combo box to supply the subform(sfrm_FunctionRequirements)for the function that is chosen and I just cant figure out how to do this...

Thanks,
SoggyCashew.....

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close