28-Jul-2006, 08:30 AM
|  | Guest | | | | | | | | | | combobox hidden column still appearing in text area
Hi y'all,
I've got a form that switches between English and Nepali, so a user can
enter data in either language. Data is stored in separate fields
according to what language it is. The user clicks a button and the form
changes its fonts and control sources.
However, switching with a combo box doesn't seem to work. When the
button is clicked, I collapse the ColumnWidths of the English fields
and expand the Nepali fields. This works for when you click on the
combobox and the menu list drops down, however, the text area for the
combobox (the Value or Text property) is stuck on the first column even
though its width has been shrunk to 0. So even if a user makes a
selection from the dropdown, all they get is gibberish (english text
translated into a nepali font isn't pretty) in the text area.
According to VB help the combobox displays the first visible column,
and shrinking a columns width to 0 automatically makes it
hidden/invisible. Has anyone else encountered this? Is there a way to
fix it?
Here's a snippet of the code:
Public Sub LangSwitch(toNepali As Boolean) Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12658-combobox-hidden-column-still-appearing-text.html
If (toNepali) Then
....
District_Label.FontName = "Preeti"
District_Label.FontSize = 13
District_Label.Caption = "lhNnf"
District.SetFocus
District.FontName = "Preeti"
District.FontSize = 13
District.ColumnWidths = "0;0;0;0;1.5 in;1.5 in;" Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
Else
....
District_Label.FontName = "MS Sans Serif"
District_Label.FontSize = 8
District_Label.Caption = "District"
'Debug.Print CStr(District.ColumnWidths)
District.ColumnWidths = "0;1 in;1 in;1 in;0;0;"
District.FontName = "MS Sans Serif"
District.FontSize = 8
End If
End Sub 
 Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh! |
28-Jul-2006, 08:31 AM
| | Guest | | | | | | | | | | Re: combobox hidden column still appearing in text area
works for me, "0;", ";0", Access 2000.
Try it without the fixed width columns "1 in" in case
that is confusing it.
(david)
"mitenko" wrote in message
news:1152166487.296141.270130@p79g2000cwp.googlegr oups.com...
> Hi y'all,
>
> I've got a form that switches between English and Nepali, so a user can
> enter data in either language. Data is stored in separate fields
> according to what language it is. The user clicks a button and the form
> changes its fonts and control sources.
>
> However, switching with a combo box doesn't seem to work. When the
> button is clicked, I collapse the ColumnWidths of the English fields
> and expand the Nepali fields. This works for when you click on the
> combobox and the menu list drops down, however, the text area for the
> combobox (the Value or Text property) is stuck on the first column even
> though its width has been shrunk to 0. So even if a user makes a
> selection from the dropdown, all they get is gibberish (english text
> translated into a nepali font isn't pretty) in the text area.
>
> According to VB help the combobox displays the first visible column,
> and shrinking a columns width to 0 automatically makes it
> hidden/invisible. Has anyone else encountered this? Is there a way to
> fix it?
>
> Here's a snippet of the code:
>
> Public Sub LangSwitch(toNepali As Boolean)
> If (toNepali) Then
> ....
> District_Label.FontName = "Preeti"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
> District_Label.FontSize = 13
> District_Label.Caption = "lhNnf"
>
> District.SetFocus
> District.FontName = "Preeti"
> District.FontSize = 13
> District.ColumnWidths = "0;0;0;0;1.5 in;1.5 in;"
> Else
> ....
> District_Label.FontName = "MS Sans Serif"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
> District_Label.FontSize = 8
> District_Label.Caption = "District"
>
> 'Debug.Print CStr(District.ColumnWidths)
> District.ColumnWidths = "0;1 in;1 in;1 in;0;0;"
> District.FontName = "MS Sans Serif"
> District.FontSize = 8
> End If
> End Sub
>
 |
28-Jul-2006, 08:31 AM
| | Guest | | | | | | | | | | Re: combobox hidden column still appearing in text area
Hi David,
thanks for the reply. I tried what you suggested but it didn't work.
I'm using Access 2003 SP2.
david epsom dot com dot au wrote:
> works for me, "0;", ";0", Access 2000.
>
> Try it without the fixed width columns "1 in" in case
> that is confusing it.
>
> (david)
>
>
>
> "mitenko" wrote in message
> news:1152166487.296141.270130@p79g2000cwp.googlegr oups.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
> > Hi y'all,
> >
> > I've got a form that switches between English and Nepali, so a user can
> > enter data in either language. Data is stored in separate fields
> > according to what language it is. The user clicks a button and the form
> > changes its fonts and control sources.
> >
> > However, switching with a combo box doesn't seem to work. When the
> > button is clicked, I collapse the ColumnWidths of the English fields
> > and expand the Nepali fields. This works for when you click on the
> > combobox and the menu list drops down, however, the text area for the
> > combobox (the Value or Text property) is stuck on the first column even
> > though its width has been shrunk to 0. So even if a user makes a
> > selection from the dropdown, all they get is gibberish (english text
> > translated into a nepali font isn't pretty) in the text area.
> >
> > According to VB help the combobox displays the first visible column,
> > and shrinking a columns width to 0 automatically makes it
> > hidden/invisible. Has anyone else encountered this? Is there a way to
> > fix it?
> >
> > Here's a snippet of the code:
> >
> > Public Sub LangSwitch(toNepali As Boolean)
> > If (toNepali) Then
> > ....
> > District_Label.FontName = "Preeti"
> > District_Label.FontSize = 13
> > District_Label.Caption = "lhNnf"
> >
> > District.SetFocus
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
> > District.FontName = "Preeti"
> > District.FontSize = 13
> > District.ColumnWidths = "0;0;0;0;1.5 in;1.5 in;"
> > Else
> > ....
> > District_Label.FontName = "MS Sans Serif"
> > District_Label.FontSize = 8
> > District_Label.Caption = "District"
> >
> > 'Debug.Print CStr(District.ColumnWidths)
> > District.ColumnWidths = "0;1 in;1 in;1 in;0;0;"
> > District.FontName = "MS Sans Serif"
> > District.FontSize = 8
> > End If
> > End Sub
> > |
28-Jul-2006, 08:31 AM
| | Guest | | | | | | | | | | Re: combobox hidden column still appearing in text area
I'll try it again with 2003 on Monday, sorry can't do more till then.
(david)
"mitenko" wrote in message
news:1152259748.895871.322980@p79g2000cwp.googlegr oups.com...
> Hi David,
>
> thanks for the reply. I tried what you suggested but it didn't work.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
>
> I'm using Access 2003 SP2.
>
> david epsom dot com dot au wrote:
>> works for me, "0;", ";0", Access 2000.
>>
>> Try it without the fixed width columns "1 in" in case
>> that is confusing it.
>>
>> (david)
>>
>>
>>
>> "mitenko" wrote in message
>> news:1152166487.296141.270130@p79g2000cwp.googlegr oups.com...
>> > Hi y'all,
>> >
>> > I've got a form that switches between English and Nepali, so a user can
>> > enter data in either language. Data is stored in separate fields
>> > according to what language it is. The user clicks a button and the form
>> > changes its fonts and control sources.
>> >
>> > However, switching with a combo box doesn't seem to work. When the
>> > button is clicked, I collapse the ColumnWidths of the English fields
>> > and expand the Nepali fields. This works for when you click on the
>> > combobox and the menu list drops down, however, the text area for the
>> > combobox (the Value or Text property) is stuck on the first column even
>> > though its width has been shrunk to 0. So even if a user makes a
>> > selection from the dropdown, all they get is gibberish (english text
>> > translated into a nepali font isn't pretty) in the text area.
>> >
>> > According to VB help the combobox displays the first visible column,
>> > and shrinking a columns width to 0 automatically makes it
>> > hidden/invisible. Has anyone else encountered this? Is there a way to
>> > fix it?
>> >
>> > Here's a snippet of the code:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
>> >
>> > Public Sub LangSwitch(toNepali As Boolean)
>> > If (toNepali) Then
>> > ....
>> > District_Label.FontName = "Preeti"
>> > District_Label.FontSize = 13
>> > District_Label.Caption = "lhNnf"
>> >
>> > District.SetFocus
>> > District.FontName = "Preeti"
>> > District.FontSize = 13
>> > District.ColumnWidths = "0;0;0;0;1.5 in;1.5 in;"
>> > Else
>> > ....
>> > District_Label.FontName = "MS Sans Serif"
>> > District_Label.FontSize = 8
>> > District_Label.Caption = "District"
>> >
>> > 'Debug.Print CStr(District.ColumnWidths)
>> > District.ColumnWidths = "0;1 in;1 in;1 in;0;0;"
>> > District.FontName = "MS Sans Serif"
>> > District.FontSize = 8
>> > End If
>> > End Sub
>> >
>
|
28-Jul-2006, 08:35 AM
| | Guest | | | | | | | | | | Re: combobox hidden column still appearing in text area
Use
Me.Recalc
or
Me.District.Requery
(david)
"david epsom dot com dot au" wrote in message
news:ORpI8GaoGHA.4504@TK2MSFTNGP04.phx.gbl...
> I'll try it again with 2003 on Monday, sorry can't do more till then.
>
> (david)
>
> "mitenko" wrote in message
> news:1152259748.895871.322980@p79g2000cwp.googlegr oups.com...
>> Hi David,
>>
>> thanks for the reply. I tried what you suggested but it didn't work.
>>
>> I'm using Access 2003 SP2.
>>
>> david epsom dot com dot au wrote:
>>> works for me, "0;", ";0", Access 2000.
>>>
>>> Try it without the fixed width columns "1 in" in case
>>> that is confusing it.
>>>
>>> (david)
>>>
>>>
>>>
>>> "mitenko" wrote in message
>>> news:1152166487.296141.270130@p79g2000cwp.googlegr oups.com...
>>> > Hi y'all,
>>> >
>>> > I've got a form that switches between English and Nepali, so a user
>>> > can
>>> > enter data in either language. Data is stored in separate fields
>>> > according to what language it is. The user clicks a button and the
>>> > form
>>> > changes its fonts and control sources.
>>> >
>>> > However, switching with a combo box doesn't seem to work. When the
>>> > button is clicked, I collapse the ColumnWidths of the English fields
>>> > and expand the Nepali fields. This works for when you click on the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
>>> > combobox and the menu list drops down, however, the text area for the
>>> > combobox (the Value or Text property) is stuck on the first column
>>> > even
>>> > though its width has been shrunk to 0. So even if a user makes a
>>> > selection from the dropdown, all they get is gibberish (english text
>>> > translated into a nepali font isn't pretty) in the text area.
>>> >
>>> > According to VB help the combobox displays the first visible column,
>>> > and shrinking a columns width to 0 automatically makes it
>>> > hidden/invisible. Has anyone else encountered this? Is there a way to
>>> > fix it?
>>> >
>>> > Here's a snippet of the code:
>>> >
>>> > Public Sub LangSwitch(toNepali As Boolean)
>>> > If (toNepali) Then
>>> > ....
>>> > District_Label.FontName = "Preeti"
>>> > District_Label.FontSize = 13
>>> > District_Label.Caption = "lhNnf"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
>>> >
>>> > District.SetFocus
>>> > District.FontName = "Preeti"
>>> > District.FontSize = 13
>>> > District.ColumnWidths = "0;0;0;0;1.5 in;1.5 in;"
>>> > Else
>>> > ....
>>> > District_Label.FontName = "MS Sans Serif"
>>> > District_Label.FontSize = 8
>>> > District_Label.Caption = "District"
>>> >
>>> > 'Debug.Print CStr(District.ColumnWidths)
>>> > District.ColumnWidths = "0;1 in;1 in;1 in;0;0;"
>>> > District.FontName = "MS Sans Serif"
>>> > District.FontSize = 8
>>> > End If
>>> > End Sub
>>> >
>>
>
>
|
28-Jul-2006, 08:40 AM
| | Guest | | | | | | | | | | Re: combobox hidden column still appearing in text area
Hi David,
I tried the Requery some time back, with no success. Unfortunately the
Recalc doesn't seem to produce any change either. Thanks for the help,
but I guess I'll have to come up with some way to work around this.
david epsom dot com dot au wrote:
> Use
> Me.Recalc
>
> or
> Me.District.Requery
>
>
> (david)
>
>
> "david epsom dot com dot au" wrote in message
> news:ORpI8GaoGHA.4504@TK2MSFTNGP04.phx.gbl...
> > I'll try it again with 2003 on Monday, sorry can't do more till then.
> >
> > (david)
> >
> > "mitenko" wrote in message
> > news:1152259748.895871.322980@p79g2000cwp.googlegr oups.com...
> >> Hi David,
> >>
> >> thanks for the reply. I tried what you suggested but it didn't work.
> >>
> >> I'm using Access 2003 SP2.
> >>
> >> david epsom dot com dot au wrote:
> >>> works for me, "0;", ";0", Access 2000.
> >>>
> >>> Try it without the fixed width columns "1 in" in case
> >>> that is confusing it.
> >>>
> >>> (david)
> >>>
> >>>
> >>>
> >>> "mitenko" wrote in message
> >>> news:1152166487.296141.270130@p79g2000cwp.googlegr oups.com...
> >>> > Hi y'all,
> >>> >
> >>> > I've got a form that switches between English and Nepali, so a user
> >>> > can
> >>> > enter data in either language. Data is stored in separate fields
> >>> > according to what language it is. The user clicks a button and the
> >>> > form
> >>> > changes its fonts and control sources.
> >>> >
> >>> > However, switching with a combo box doesn't seem to work. When the
> >>> > button is clicked, I collapse the ColumnWidths of the English fields
> >>> > and expand the Nepali fields. This works for when you click on the
> >>> > combobox and the menu list drops down, however, the text area for the
> >>> > combobox (the Value or Text property) is stuck on the first column
> >>> > even
> >>> > though its width has been shrunk to 0. So even if a user makes a
> >>> > selection from the dropdown, all they get is gibberish (english text
> >>> > translated into a nepali font isn't pretty) in the text area.
> >>> >
> >>> > According to VB help the combobox displays the first visible column,
> >>> > and shrinking a columns width to 0 automatically makes it
> >>> > hidden/invisible. Has anyone else encountered this? Is there a way to
> >>> > fix it?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
> >>> >
> >>> > Here's a snippet of the code:
> >>> >
> >>> > Public Sub LangSwitch(toNepali As Boolean)
> >>> > If (toNepali) Then
> >>> > ....
> >>> > District_Label.FontName = "Preeti"
> >>> > District_Label.FontSize = 13
> >>> > District_Label.Caption = "lhNnf"
> >>> >
> >>> > District.SetFocus
> >>> > District.FontName = "Preeti"
> >>> > District.FontSize = 13
> >>> > District.ColumnWidths = "0;0;0;0;1.5 in;1.5 in;"
> >>> > Else
> >>> > ....
> >>> > District_Label.FontName = "MS Sans Serif"
> >>> > District_Label.FontSize = 8
> >>> > District_Label.Caption = "District"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
> >>> >
> >>> > 'Debug.Print CStr(District.ColumnWidths)
> >>> > District.ColumnWidths = "0;1 in;1 in;1 in;0;0;"
> >>> > District.FontName = "MS Sans Serif"
> >>> > District.FontSize = 8
> >>> > End If
> >>> > End Sub
> >>> >
> >>
> >
> > |
28-Jul-2006, 08:40 AM
| | Guest | | | | | | | | | | Re: combobox hidden column still appearing in text area
Both worked for me, Access 2003
(david)
"mitenko" wrote in message
news:1153716588.558153.159250@i42g2000cwa.googlegr oups.com...
> Hi David,
>
> I tried the Requery some time back, with no success. Unfortunately the
> Recalc doesn't seem to produce any change either. Thanks for the help,
> but I guess I'll have to come up with some way to work around this.
>
> david epsom dot com dot au wrote:
>> Use
>> Me.Recalc
>>
>> or
>> Me.District.Requery
>>
>>
>> (david)
>>
>>
>> "david epsom dot com dot au" wrote in message
>> news:ORpI8GaoGHA.4504@TK2MSFTNGP04.phx.gbl...
>> > I'll try it again with 2003 on Monday, sorry can't do more till then.
>> >
>> > (david)
>> >
>> > "mitenko" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
>> > news:1152259748.895871.322980@p79g2000cwp.googlegr oups.com...
>> >> Hi David,
>> >>
>> >> thanks for the reply. I tried what you suggested but it didn't work.
>> >>
>> >> I'm using Access 2003 SP2.
>> >>
>> >> david epsom dot com dot au wrote:
>> >>> works for me, "0;", ";0", Access 2000.
>> >>>
>> >>> Try it without the fixed width columns "1 in" in case
>> >>> that is confusing it.
>> >>>
>> >>> (david)
>> >>>
>> >>>
>> >>>
>> >>> "mitenko" wrote in message
>> >>> news:1152166487.296141.270130@p79g2000cwp.googlegr oups.com...
>> >>> > Hi y'all,
>> >>> >
>> >>> > I've got a form that switches between English and Nepali, so a user
>> >>> > can
>> >>> > enter data in either language. Data is stored in separate fields
>> >>> > according to what language it is. The user clicks a button and the
>> >>> > form
>> >>> > changes its fonts and control sources.
>> >>> >
>> >>> > However, switching with a combo box doesn't seem to work. When the
>> >>> > button is clicked, I collapse the ColumnWidths of the English
>> >>> > fields
>> >>> > and expand the Nepali fields. This works for when you click on the
>> >>> > combobox and the menu list drops down, however, the text area for
>> >>> > the
>> >>> > combobox (the Value or Text property) is stuck on the first column
>> >>> > even
>> >>> > though its width has been shrunk to 0. So even if a user makes a
>> >>> > selection from the dropdown, all they get is gibberish (english
>> >>> > text
>> >>> > translated into a nepali font isn't pretty) in the text area.
>> >>> >
>> >>> > According to VB help the combobox displays the first visible
>> >>> > column,
>> >>> > and shrinking a columns width to 0 automatically makes it
>> >>> > hidden/invisible. Has anyone else encountered this? Is there a way
>> >>> > to
>> >>> > fix it?
>> >>> >
>> >>> > Here's a snippet of the code:
>> >>> >
>> >>> > Public Sub LangSwitch(toNepali As Boolean)
>> >>> > If (toNepali) Then
>> >>> > ....
>> >>> > District_Label.FontName = "Preeti"
>> >>> > District_Label.FontSize = 13
>> >>> > District_Label.Caption = "lhNnf"
>> >>> >
>> >>> > District.SetFocus
>> >>> > District.FontName = "Preeti"
>> >>> > District.FontSize = 13
>> >>> > District.ColumnWidths = "0;0;0;0;1.5 in;1.5 in;"
>> >>> > Else
>> >>> > ....
>> >>> > District_Label.FontName = "MS Sans Serif"
>> >>> > District_Label.FontSize = 8
>> >>> > District_Label.Caption = "District"
>> >>> >
>> >>> > 'Debug.Print CStr(District.ColumnWidths)
>> >>> > District.ColumnWidths = "0;1 in;1 in;1 in;0;0;"
>> >>> > District.FontName = "MS Sans Serif"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12658
>> >>> > District.FontSize = 8
>> >>> > End If
>> >>> > End Sub
>> >>> >
>> >>
>> >
>> >
>
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Gurbani Jukebox |  Listen to Gurbani while surfing SPN! | | » Active Discussions | | | | | | |  ਨਾਮਾ Today 06:37 AM 2 Replies, 53 Views | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
