Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-05-2019, 04:55 AM   #16
Frothingslosh
Premier Pale Stale Ale
 
Frothingslosh's Avatar
 
Join Date: Oct 2012
Location: Flint, Michigan, USA
Posts: 3,211
Thanks: 83
Thanked 457 Times in 413 Posts
Frothingslosh will become famous soon enough Frothingslosh will become famous soon enough
Re: Combo Box Length Limit?

Jdraw - that's why I said 'that user' and not 'that woman'. This time the User From Hell just happens to be a woman. Last place I worked, it was a guy.

The comments are hand-written explanations of why this particular case was rejected by Medicare, and are required to be precisely what we were told for legal reasons. This mechanism is there so that when CMS provides us with a novel, they don't have to type it individually for a thousand or more different claims. The lookup portion is because the same reason might be provided for different people or claims after calls to CMS on different days.

TBQH, I'm far more likely to just remove the whole 'select previous comments' thing altogether and tell them to continue using copy and paste than I am to go against the express instructions of my department manager and completely rework this form from the ground up without authorization (from either users or management) the way people are suggesting here. What I'm most likely to do, however, is leave it alone and tell them to suck it up.

I spent an hour of work looking into determining if a fix was possible. It isn't, and the suggestions here not only would absolutely be rejected by a user who would turn the entire thing into a political clusterf*** of epic proportions, but implementing them would directly violate the manager's instructions that significant changes may only be performed after approval from users and management. I could have gotten away with making the box stop cutting off the text because that could be called a fix. I cannot get away with actually changing the UI without good reason, and this is not good enough reason, since they already have a workaround (they just copy and paste from the original comment).

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Frothingslosh is offline   Reply With Quote
Old 01-05-2019, 08:04 AM   #17
Frothingslosh
Premier Pale Stale Ale
 
Frothingslosh's Avatar
 
Join Date: Oct 2012
Location: Flint, Michigan, USA
Posts: 3,211
Thanks: 83
Thanked 457 Times in 413 Posts
Frothingslosh will become famous soon enough Frothingslosh will become famous soon enough
Re: Combo Box Length Limit?

Sorry, guys, I'm grouchy and irritable this morning for some reason. (Moreso than normal.)

I do appreciate the suggestions, even though I can't implement them due to other concerns.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Frothingslosh is offline   Reply With Quote
Old 01-05-2019, 09:02 AM   #18
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,218
Thanks: 29
Thanked 280 Times in 266 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: Combo Box Length Limit?

Quote:
What's happening is that when a comment is over 255 characters in length, it's truncated at 255. The table contains the entire comment, no matter the size. The query behind the combobox passes the entire comment. The combobox itself, however, never shows more than 255 characters.
Would it be possible to use NVARCHAR(MAX) as your field size? I have never tried it because the goal is to be stingy on field size.

AccessBlaster is online now   Reply With Quote
Old 01-05-2019, 11:37 AM   #19
Frothingslosh
Premier Pale Stale Ale
 
Frothingslosh's Avatar
 
Join Date: Oct 2012
Location: Flint, Michigan, USA
Posts: 3,211
Thanks: 83
Thanked 457 Times in 413 Posts
Frothingslosh will become famous soon enough Frothingslosh will become famous soon enough
Re: Combo Box Length Limit?

According to one of the links provided earlier, combo boxes just truncate text fields at 255, period.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Frothingslosh is offline   Reply With Quote
Reply

Tags
combo box , combo box fields display

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VBA - Limit on string length using Mailto: and shell32.dll wdhewitt Modules & VBA 0 01-09-2013 06:30 PM
Image Size - Scrolling and Length Limit Geezer Forms 1 07-14-2008 06:34 PM
Limit Character length with combo tl mike Modules & VBA 9 03-14-2008 02:55 PM
Import Record 495 character Length Limit? Kevin Crowley Tables 2 05-04-2005 08:39 AM
get round limit in the path length D.Mair Modules & VBA 9 01-18-2002 03:23 AM




All times are GMT -8. The time now is 03:27 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World