<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>Hi everyone - hoping for some help
with a strange error that I have never run into before..</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Users are entering data into a combo
box bound to a field called CostID. The Combo has 3 columns - CostID,
CostDescription and DefaultCost. </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>As usual, the width of the first
column is set to 0 and it is the bound column, so that the users only see the
description column, and when they make a selection I store the id.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>The problem is that the description
field is a text field with a 100 char limit. But as the users type into the
combo control to enter a new cost, the field isn't limiting them to the 100
chars. It is as if the combo ignores the real length of the 2nd column of its
row source.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>The second part of the problem is
that when they are entering a new cost, I have </FONT><FONT face=Arial
color=#0000ff size=2>'notinlist' code in place which opens a new form so
that staff can add more details for new records. But when the form attempts
to load the openargs property from the first form, it throws an error 'attempted
to paste too much data..." etc.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>I know I can use code to truncate the
field after it has been entered, but what I want to is to limit them users
back in the first place to only be able to enter 100 chars. I have played around
with input masks, eg'CCCCCCCCCCCCCCC' etc for 100 chars but they look awful when
displayed. The row source of the combo is as below:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>The CostID field gas 3 columns
and has a row source of </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>"SELECT TBLLUCostTypes.CostType,
TBLLUCostTypes.CostDescription, TBLLUCostTypes.DefaultCost FROM TBLLUCostTypes
ORDER BY TBLLUCostTypes.CostDescription;"</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Any tips?</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath Pelletti<BR>Software Design
& Solutions Pty Ltd.<BR>Ph: 9505-6714<BR>Fax: 9505-6430<BR><A
href="mailto:sdssoftware@optusnet.com.au">sdssoftware@optusnet.com.au</A></FONT></DIV></BODY></HTML>